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


Please Help Members By Posting Answers For Below Questions

what are the different types of SSRS reports?

122


Tell me the phases a transaction has to undergo?

721


What is transaction server implicit?

693


What are the new features in sql server 2016?

716


Explain nested join?

744


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?

763


How to define and use table alias names in ms sql server?

750


Different types of keys in SQL?

827


What information is maintained within the msdb database?

729


How does using a separate hard drive for several database objects improves performance right away?

707


Where views are stored in sql server?

734


what's the difference between a primary key and a unique key? : Sql server database administration

695


What is the stuff and how does it differ from the replace function?

740


Do you know what is user defined datatypes and when you should go for them?

717


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1978