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
What is indexed view?
Explain what is the difference between union and union all?
how to invoke a trigger on demand? : Sql server database administration
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the database roles? : sql server security
How many columns can we include on clustered index ?
What is the significance of null value and why should we avoid permitting null values?
How to count duplicated values in a column in ms sql server?
wat wil hapn if we give the both read and deny read permission to user?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the synonym of join?
What is reportserver and reportservertempdb ?
What are the different sql server versions?
Is mysql better than sql server?