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


Please Help Members By Posting Answers For Below Questions

Why normalization is used?

548


What is a recursive stored procedure in sql server?

569


What are data driven subscriptions?

79


What is difference statement and preparedstatement?

545


How you trouble shoot when any job fails

1501






How do I schedule a sql server profiler trace?

538


Explain identity in sql server?

561


How to get the number of affected rows?

558


Explain the usage of floor function in sql server.

499


How to get nth highest salary from employee table.

613


Explain what are page splits? : SQL Server Architecture

652


What is an execution plan?

564


How do I determine how many instances of sql server are installed on a computer?

531


What is the stored procedure?

557


How to list all objects in a given schema?

558