Let us assume that Table Name:salary Coloumn Name:maxsal(int) select *

Write a query to find second highest salary of an employee.

Question Posted / akilis.org@hotmail.com

Answer Posted / akilis.org@hotmail.com

Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we join same table in sql?

959

Is not null in sql?

924

What does seeding a database mean?

889

What are the ways on commenting in a pl/sql code?

1048

is mysql query is case sensitive? : Sql dba

1029

Is merge a dml statement?

921

What are the advantages of indexing?

926

what is the difference difference between procedure and packages

10246

What does := mean in pl sql?

989

How many times can we commit in a loop?

955

Does truncate free space?

943

What are types of joins?

905

Is sqlite free?

907

how do you control the max size of a heap table? : Sql dba

919

What is scope and visibility in PL/SQL?

1110