Interested to Buy Any Domain ? << Click Here >> for more details...
How to select Distinct columns from the table, table having
20 columns and i want all coulmns
- 5 Answers
- 10937 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / monal
To select distinct columns you can mention them in the SQL
query and to select all columns you can use select * from
information_schema.columns
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
1 01 101 01010
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What are the advantages of partitioning?
What is normalization? What number of normalization shapes are there?
How to delete duplicate rows in sql server?
Tell me what are the essential components of sql server service broker?
What is a view and what are its advantages?
Do you know what is openxml in sql server?
What is difference between clustered index and non clustered index?
What do you mean by authentication modes in sql server?
List out some of the requirements to set up a sql server failover cluster?
What are dml (data manipulation language) statements in ms sql server?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
