select salary from employee order by salary DESC LIMIT(1,1);

how to find the second highest salary from emp table?

Question Posted / nirjesh pandey

211 Answers
361415 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / nirjesh pandey

select salary from employee order by salary DESC LIMIT(1,1);

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is union, minus and interact commands? : Sql dba

1123

Can we use threading in pl/sql?

975

Can primary key be changed?

871

What is microsoft t sql?

882

What is meant by <> in sql?

895

How to change the order of columns in Oracle SQL Plus ?

998

What is synchronized subquery?

1094

Is sql a scripting language?

924

What do we need to check in database testing?

966

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537

what tools available for managing mysql server? : Sql dba

1011

what is the different between now() and current_date()? : Sql dba

938

Name the operator which is used in the query for pattern matching?

894

how to create a new table in mysql? : Sql dba

934

Is mariadb a nosql database?

1007