Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
iNko
Starting Member
19 Posts |
Posted - 2012-12-09 : 09:18:14
|
Hello, i have a table witch has 3 columns:Table1ID GROUP_NAME USER1 Administrator John2 Administrator Dave3 Moderator James4 IT TomI want to show all group names, without showing duplicates, can i do this?Example:SELECT GROUP_NAME FROM Table1Result:AdministratorAdministratorModeratorITWhat i want to display:AdministratorModeratorITPlease help |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-09 : 10:16:19
|
[code]SELECT distinct GROUP_NAME FROM Table1[/code]Or you want to show individual name per group[code]Select * from(SELECT *,ROW_NUMBER() OVER(PARTITION BY GROUP_NAME ORDER BY USER)as SeqFROM Table1)PWhere Seq = 1[/code] |
|
|
iNko
Starting Member
19 Posts |
Posted - 2012-12-09 : 10:47:13
|
Thank you! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-09 : 11:04:41
|
NP |
|
|
|
|
|