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
Does sql server use t sql?
What is inline variable assignment?
How to maintain a fill factor in existing indexes?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is tempdb database? : SQL Server Architecture
What are the main differences between #temp tables and @table variables and which one is preferred?
What are number line correlation administrators will use while working with a subquery?
Do you know the cursor optimization tips?
What is a system database and what is a user database?
Describe how to use the linked server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What are the export options of ssrs?
Describe in brief databases and sql server databases architecture.
What is clustered primary key?
what is the difference between delete table and truncate table commands? : Sql server database administration