How to select Distinct columns from the table, table having
20 columns and i want all coulmns
Answer Posted / latha.s
select distinct * from tablename;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
When a primary key constraint is included in a table, what other constraints does this imply?
What are sql server functions?
What is awe?
What is the cartesian product of the table?
What type of locking occurs during the snapshot generation? : sql server replication
Define inner join? Explain with an example?
What's new in sql management studio for sql server? : sql server management studio
What is inline table-value user-defined function?
Do you know what are acid properties?
What are dml (data manipulation language) statements in ms sql server?
What are the steps you should follow to start sql server in single-user mode?
Characterize join and name diverse sorts of joins?
What is attribute hierarchy? : sql server analysis services, ssas
Is foreign key a primary key?
Detail about query optimizer?