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";

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

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

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة