how can u select the Distinct values in the table, table
having 20 columns , i want all columns
Answer Posted / krishnamoorthy.n
select distinct * from <tablename>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
what's the difference between a primary key and a unique key? : Sql server database administration
in the physical file layout, where should the transaction log be stored in relation to the data file?
Why are sql functions used?
What are the system database in sql server 2005?
How will you hide an attribute? : sql server analysis services, ssas
What is the Disadvantage of indexed sequential file.
What is the main difference between ‘between’ and ‘in’ condition operators?
What are partitioned views?
How do you clear a log file?
Where are stored procedures in sql server?
What are cascading parameters in ssrs reports?
Write a query for primary key constraint with identity key word?
Write an sql query for deleting duplicate rows?
What is row_number () and partition by in sql server?
What is the difference between for trigger and after trigger?