select slary from emp order by slary desc limit 1,1;

how to find the second highest salary from emp table?

Question Posted / chandan

Answer Posted / chandan

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are all ddl commands?

1015

Why are sql stored procedures used?

990

What are the three pl sql block types?

949

What are field types?

942

What is procedure in pl sql?

980

How to get unique records from a table?

898

What is view explain with example?

887

What is sql trigger example?

1000

Can we edit a view in sql?

927

What are the ddl commands?

951

What is a left inner join?

948

Is it important to partition hard disk?

967

is mysql query is case sensitive? : Sql dba

1031

What is the difference between function and procedure in pl/sql?

1017

what is bcp? When does it used? : Sql dba

935