Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Finding column with same value in another column
- Thread starter DarVar
- Start date
Something like this ?
SELECT DISTINCT name
FROM yourTable
WHERE label = 'yourLabel'
Or this ?
SELECT label, name
FROM yourTable
GROUP BY label, name
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
SELECT DISTINCT name
FROM yourTable
WHERE label = 'yourLabel'
Or this ?
SELECT label, name
FROM yourTable
GROUP BY label, name
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Status
Similar threads
- Locked
- Question