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
- 11094 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
What are the disadvantages of primary key and foreign key in SQL?
How to recover from sql injection? : sql server security
What is amo? : sql server analysis services, ssas
How sql server enhances scalability of the database system?
What are the differences between ms sql server & oracle?
How to count groups returned with the group by clause in ms sql server?
Explain security with sql azure?
How do I view a stored procedure in sql server?
What are the requirements for sql server 2016?
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?
What is the difference between executequery () and executeupdate ()?
what is a mixed extent? : Sql server administration
How to defragment indexes with alter index ... Reorganize?
Do you know the cursor optimization tips?
Can I delete event logs?
