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 side by side migration in sql server?
What are the 7 disadvantages to a manual system?
What is resource db in sql server?
What is table value parameters (tvp)?
Can sql servers link to other servers?
Why use “in” clause in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
what method you can use to reduce the overhead of Reporting Services data sources?
What is a ddl statement?
What is a bit datatype?
How can I check if a view exists in a sql server database?
How to achieve Paging of records in SQL SERVER?
What is apply operator in sql?
What are the triggers in sql?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?