How to select Distinct columns from the table, table having
20 columns and i want all coulmns
Answer Posted / amit
select distinct * from table_name
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
What stored by the model? : sql server database administration
Explain various data region available in ssrs with their use?
What is xml datatype?
What is the difference between primary key and unique constraints?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is implicit mode in sql server?
What are audit control procedures?
What are different types of subquery?
What is the meaning of resultset type_scroll_insensitive?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is difference between cte and view?
What are types of storage modes? : sql server analysis services, ssas
What is difference between clustered index and non clustered index?
How to provide login information for a new odbc dsn?