how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 6483 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnamoorthy.n
select distinct * from <tablename>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is sql server schema compare? How we can compare two database schemas?
What are the advantages of log shipping?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Explain different types of lock modes in sql server 2000?
What is nonclustered index on computed columns?
Do you know exporting and importing utility?
What is the maximum size of sql server database?
How do I run a trace in sql server?
How do you delete a data source?
What is reference section?
What is a database in ms sql server?
What do you mean by an execution plan? How would you view it?
What is not null constraint?
Explain magic tables in sql server?
