1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / rajesh.m

Answer Posted / rajesh.m

Crete Table Curtest(Emp char(40),salary money)
------------------------------------------------
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest)

--------------------------------------------------

Is This Answer Correct ?    21 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use %rowtype & %type in plsql?

593

How do I pipe the output of one isql to another?

524

What is primary key and unique key?

537

What are the 3 modes of parameter?

675

What is a .db file?

531




what are the authentication modes in sql server? How can it be changed? : Sql dba

695

What is difference sql and mysql?

527

How do you use collections in procedure to return the resultset?

1782

What are sql objects?

534

What is the syntax to add a record to a table?

569

What is string data type in sql?

525

What is the difference among union, minus and intersect?

538

What is full join?

517

explain the difference between myisam static and myisam dynamic. : Sql dba

509

what is 'trigger' in sql? : Sql dba

553