Interested to Buy Any Domain ? << Click Here >> for more details...
how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 7411 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnamoorthy.n
select distinct * from <tablename>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Tell me about builtinadministrator?
What is filter index?
How to write a query with a right outer join in ms sql server?
How to Check if table exists in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
How do I save a stored procedure in sql server?
What is the purpose of self join?
What options are available to audit login activity? : sql server security
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
How do you manipulate data?
How to get the query of a table in sql server?
Write a SQL query to make a column as unique?
What is xml datatype?
How self join is different from outer join?
How do I debug a stored procedure in sql server?
