How to check if two or more rows have the same field value?

Question

I want to filter details from db.

Database Example:

I want to select the first row with the last name "usama" and then I want to skip the next row which has the same field "usama".

any ideas ?

Haitham Nabil Baioumi · Answer

------------------------------------------------------------------------------
select *
from table_name
where last_name = "usama"
LIMIT1
------------------------------------------------------------------------------
this will return the first occurance of last_name usama

Usama Saad · Answer

حنان يزه · Answer

select *
from table_name
where last_name="usama";

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

How to check if two or more rows have the same field value?

Recherches Populaires

More Questions Like This