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 are the different types of SSRS reports?
Tell me the phases a transaction has to undergo?
What is transaction server implicit?
What are the new features in sql server 2016?
Explain nested join?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to define and use table alias names in ms sql server?
Different types of keys in SQL?
What information is maintained within the msdb database?
How does using a separate hard drive for several database objects improves performance right away?
Where views are stored in sql server?
what's the difference between a primary key and a unique key? : Sql server database administration
What is the stuff and how does it differ from the replace function?
Do you know what is user defined datatypes and when you should go for them?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail