Answer Posted / udaya
select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
How do you drop an index?
Explain error and transaction handling in sql server?
What are the different types of locks in the database?
What is a functions and types in sql server?
What are cursors stored procedures and triggers?
how to take backup bcp out for a column in table in sql server?
What is triggers and its types?
How to create a user to access a database in ms sql server using "create user" statements?
What is the difference between truncate and delete commands?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is the difference between row_number and dense_rank?
How to enable tcp/ip protocol on a sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What are the kinds of subquery?
What is indexed view? How to create it?