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
What is spatial and temporal data?
What is ddl and dml commands?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How many instances per computer are there in sql server 2000?
List out a number of the wants to setup a SQL Server failover cluster?
How to create a new login name in ms sql server?
What do you understand by triggers?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Define left outer join in sql server joins?
What is the contrast between sql and pl/sql?
What is difference between rownum and row_number?
Differentiate between a local and a global temporary table?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?