How to select Distinct columns from the table, table having
20 columns and i want all coulmns
- 5 Answers
- 10024 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / latha.s
select distinct * from tablename;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Disadvantages of the indexes?
How to enable/disable indexes?
What is transaction server consistency?
How many instances per computer are there in sql server 2000?
What are the types of containers in ssis?
Is it safe to delete log files?
Can sql servers linked to other servers?
Differentiate between a primary key and a unique key.
What is function of ROLLUP ?
which backup strategy you are following at ur company
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What function does a database engine serve in the sql server?
How to copy data from one table to another table?
Why do you want to join software field as you have done your BE in Electronics?
Name 3 ways to get an accurate count of the number of records in a table?
