Thread
:
Select Query with different fields
View Single Post
#
2
(
permalink
)
02-05-2008, 11:17 PM
Dimitar
Posts: n/a
ANY
answer.
Re: Select Query with different fields
Hi,
Does this solve the issue:
Code:
SELECT email, max(firstname),max(lastname) FROM t GROUP BY email;
If yes, you could consult your SQL manual about grouping and grouping functions that filter results within each group.
Hope this helps,
Dimitar
Dimitar