select max(sal)*from emp where sal>select max(sal)*from emp

how to find nth highest salary

Question Posted / haribabuboddapati

Answer Posted / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

Is This Answer Correct ?

24 Yes

100 No

Please Help Members By Posting Answers For Below Questions

What is rolap and its advantage? : sql server analysis services, ssas

1333

What is the synonym of join?

1018

How many database files are there in sql server 2000?what are they?

1111

What causes index fragmentation?

1048

Explain ranking functions?

1099

Is it possible to have clustered index on separate drive from original table location?

1018

What are cursors and when they are useful?

1153

What do you understand by the data quality services in sql server?

984

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1076

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1067

How to create nested stored procedure?

1074

write an SQL query to list the employees who joined in the month of January?

1741

What are the different types of sql server replication? : sql server replication

1369

Where can you find the error log information? : sql server database administration

1072

How to edit table in sql server 2017?

982