Skip to main content
AI Assist is now on Stack Overflow. Start a chat to get instant answers from across the network. Sign up to save and share your chats.

Return to Answer

deleted 4 characters in body
Source Link
Setmax
Setmax
  • 1k
  • 8
  • 11

use this(assume that your table name is emails): select * from emails as a inner join
( select EmailAddress, min(Id) as id from emails group by EmailAddress ) as b on a.EmailAddress = b.EmailAddress and a.Id = b.id hope

select * from emails as a inner join (select EmailAddress, min(Id) as id from emails group by EmailAddress ) as b on a.EmailAddress = b.EmailAddress and a.Id = b.id

hope this help..

use this(assume that your table name is emails): select * from emails as a inner join
( select EmailAddress, min(Id) as id from emails group by EmailAddress ) as b on a.EmailAddress = b.EmailAddress and a.Id = b.id hope this help..

use this(assume that your table name is emails):

select * from emails as a inner join (select EmailAddress, min(Id) as id from emails group by EmailAddress ) as b on a.EmailAddress = b.EmailAddress and a.Id = b.id

hope this help..

Source Link
Setmax
Setmax
  • 1k
  • 8
  • 11

use this(assume that your table name is emails): select * from emails as a inner join
( select EmailAddress, min(Id) as id from emails group by EmailAddress ) as b on a.EmailAddress = b.EmailAddress and a.Id = b.id hope this help..