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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-10 : 09:38:58
|
| kiran writes "How can I get unique values from the data base" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-10 : 09:41:00
|
select newid()
KH |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-04-10 : 09:41:23
|
| Try:SELECT DISTINCT [YourColumns] FROM [YourTable] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-10 : 11:17:21
|
hmmmm did i read the question wrongly ? 
KH |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-04-10 : 12:00:16
|
| One of us did, guaranteed. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-10 : 13:28:19
|
Add unique contraints.Can't help chipping in  |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-04-10 : 13:47:35
|
quote:
Originally posted by AskSQLTeam
kiran writes "How can I get unique values from the data base"
Unique up on dem vewy qwietly. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-10 : 15:02:26
|
| *LOL* |
|
|
|
|
|
|
get the unique values