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
- 10936 Views
- Wipro, I also Faced
- E-Mail Answers
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
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?
Tell me what is a linked server?
What is the difference between upgrade and migration in sql server?
What is a self join in sql server?
Do you know how to store and query spatial data?
Write the SQL query to drop, truncate and delete table.
what stored procedure would you use to view lock information? : Sql server administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are partitioned views?
How do I delete a sql server database?
Tell me what is normalization? Explain different forms of normalization?
Working with TLogs
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How do I start sql server 2017?
What is default port number for sql server 2000?
