SQL Server - how to select record based on distinct one column ?

hi...i have sareenumber with multiple duplicate value in my table...and i need select record based on distinct sareenumber..
any help??

hi,

Using this for getting records,

Select * from tbl_name group by sareeno=&sareeno;

 

Or using distinct keyword

 

SELECT DISTINCT columnName(s)

FROM tableName

Regards,

Please elaborate your requirement bit more clearly.

i have saree number with duplicate values and i need to select record with distinct row based on sareenumber only..so i need to avoid duplicate record with sareenumber

chesk this,
  a similar example is explained here,

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/f1445312-cde7-4b62-8c05-e21fd8b2eb35

Hope it helps you.

If you have different values in other columns for sareenumber, then you would not be able to get the distinct data of sareenumber using select *.
Distinct operator works on all columns used in select. if the whole row data is same then only it would give a single row for duplicate rows.

Post some sample data and desired output.

If you have no unique identifier, how would you propose that the query decide which non-unique row to return?  One possibility is the Top values predicate.

Select Top 1 yourtable.*
From yourtable
Where  somefield = somevalue;