select top 1 (salary),Name from customers where salary not in (Select to

how to check the 3rd max salary from an employee table?

Question Posted / pavan ranga

Answer Posted / pavan ranga

select top 1 (salary),Name from customers
where salary not in (Select top 2 (Salary) from customers)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the types of joins in sql?

1035

Can we create a trigger on view?

901

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1018

How do you optimize a query?

1008

What are inner and outer joins examples of both?

965

how to use regular expression in pattern match conditions? : Sql dba

1036

What are character functions in sql?

943

What is recursive stored procedure?

1101

What are the uses of sysdate and user keywords?

1105

How show all rows in sql?

1016

Is pl sql different from sql?

1002

What are the parts of a basic sql query?

968

Does sql full backup truncate logs?

1021

How do you run a query?

995

Define tables and fields in a database

1136