Interested to Buy Any Domain ? << Click Here >> for more details...
How to select Distinct columns from the table, table having
20 columns and i want all coulmns
- 5 Answers
- 10777 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / monal
To select distinct columns you can mention them in the SQL
query and to select all columns you can use select * from
information_schema.columns
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain isolation levels that sql server supports?
Why truncate is ddl?
what is the difference between openrowset and openquery?
What is compound operators?
What happens if null values are involved in bitwise operations?
How many types of database relationship in sql server?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Is there any difference between the primary key and unique key?
What is the use of stored procedure?
You want to use a perspective in an mdx query. How do you select the perspective?
What is schemabinding a view?
What is sql server english query?
Explain what are magic tables in sql server?
What are the different type of replication in sql server?
