Menu
I’ve got a select statement that I know is wrong, but don’t know how to fix it. What I want to do is show the first record in the table for each different value in the UID field. Here’s a sample table with the ones I don’t want to show in bold. The current incorrect select statement is below the sample table. Any help would be greatly appreciated. Thanks!
[U]UID ———- LoginID
1000 ———- 1
1005 ———- 2
1010 ———- 3
1015 ———- 4
1100 ———- 5
[B]1000
1120 ———- 7
[B]1015
[code]
SELECT DISTINCT(UID), LoginID FROM tblPURLHits ORDER BY LoginID