DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
How to select only the first rows for each unique value of a sql tablecolumn?
SELECT CName, MIN(AddressLine) FROM MyTable GROUP BY CName
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#How
#select
#rows
#unique
#sql
ADD COMMENT
Topic
COMMENT
Name
5+1 =
Submit