Distinct is just a group by on all columns, so either of the queries
you showed should be pretty much the same. The difference
between the two shows up when you have multiple columns in
your select. ie
Select distinct id,name from table1;
and
Select id,name from table1 group by name;
do two di
Tom: if you need to weed out duplicates you may try knowing which entries
duplicate themselves and how many times they are duplicated, why don't you
try.
SELECT seminar_name COUNT(*)
FROM student_table GROUP BY seminar_name
This will return the seminar_name field plus a COUNT field that will dis
I've never heard of select distinct not working...
Is that the exact SQL you are using?
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/vol
3 matches
Mail list logo
