How to select Distinct columns from the table, table having
20 columns and i want all coulmns
Answer Posted / saleem
select *from tablename gives all distinct columns in the
table
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is an sql server agent?
What is a non-clustered index?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are recommended options to be used while using db mirroring? : sql server database administration
What is an identity column in insert statements?
What is the usage of the sign function?
What is transactional replication?
How do I run a trace in sql server?
Which database stores information about replication?
why would you use sql agent? : Sql server database administration
How to connect ms access to sql servers through odbc?
What is an indexed view?
Which table keeps information about stored procedures?
Explain the first normal form(1nf)?