select salary max(salary) from emp limit1 offset1

how to find the second highest salary from emp table?

Question Posted / bhoopendra vishwakarma

Answer Posted / bhoopendra vishwakarma

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you define a foreign key?

993

How do you rename a table in sql?

1102

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1214

What are two statement types in sql?

1086

What is a behavioral trigger?

970

What are the popular database management systems in the it industry?

995

What is record in pl sql?

1079

How do I upgrade sql?

998

Explain what is rdbms?

1027

What are the advantages of pl sql over sql?

1021

What is dynamic sql in pl sql?

1030

What is the purpose of my sql?

943

What's the procedure?

922

What is difference between ms sql and mysql?

959

What is trigger types in sql?

989