select sal from emp order by salary desc limit 1,1

how to find the second highest salary from emp table?

Question Posted / hima

Answer Posted / hima

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you write an index?

962

How does join work in sql?

1007

What is anonymous block in sql?

1120

How do you update a table in sql?

984

What is denormalization in a database?

1052

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

How do I upgrade sql?

998

What are the sql versions?

940

What is character functions?

1060

Is oracle sql free?

982

What are the different types of tables in sql?

1005

how to include character strings in sql statements? : Sql dba

1067

What is union and union all keyword in sql and what are their differences?

1100

what is meant by urlencode and urldocode? : Sql dba

1172

How do I quit sql?

952