By using the rank function we can get the 2nd highest salary from the emp

how to find the second highest salary from emp table?

Question Posted / avinav

Answer Posted / avinav

By using the rank function we can get the 2nd highest
salary from the emp table

Is This Answer Correct ?

10 Yes

25 No

Please Help Members By Posting Answers For Below Questions

How to add, remove, modify users using sql?

980

What is the difference between python and sql?

940

What are different types of sql?

1100

How do we use distinct statement? What is its use?

977

Is sql a backend?

968

How do I kill a query in postgresql?

1014

What is primary key and foreign key?

917

What is sql partition function?

1120

What are types of exception?

876

how can you see all indexes defined for a table? : Sql dba

936

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1041

What is informix sql?

924

Does truncate require commit?

921

What is primary and foreign key?

1017

Is sql low level language?

963