Quick question
Posted: Fri Mar 24, 2006 11:00 am
Sorry about the uninformative title.
I have a table in which I have a few rows. I want to pull the first four rows, but I want to make sure that one of the feilds is different in each of them. So something like this:
id | name | birthday
1 evilmonkey 12/02/87
2 emjokes 15/05/75
3 user124 18/12/83
4 pseudo12 15/05/75
5 apple_pie 29/01/90
See, emjokes and pseudo12 have the same birthday. I want to select only emjokes in that case. (BTW, this isn't for birthdays, it's for something else.
) It's only for one feild (in this case, I only don't want matching birthdays.) How can I set up a query for that?
Thanks.
id | name | birthday
1 evilmonkey 12/02/87
2 emjokes 15/05/75
3 user124 18/12/83
4 pseudo12 15/05/75
5 apple_pie 29/01/90
See, emjokes and pseudo12 have the same birthday. I want to select only emjokes in that case. (BTW, this isn't for birthdays, it's for something else.
Thanks.