use this query. it works great. select max(sal) from table

how to find the second highest salary from emp table?

Question Posted / bipin

211 Answers
373215 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 / bipin

use this query. it works great.

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?

415 Yes

59 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a table in a database?

1096

How are functions and procedures called in PL/SQL?

1309

What is the use of & in pl sql?

1098

Is hadoop a nosql?

1054

What is a database trigger?

1138

How to write pl sql program in mysql command prompt?

1165

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2139

what is the command line end user interface - mysql? : Sql dba

1031

Which operator is used in query for pattern matching?

1133

Why having clause is used in sql?

1021

What is crud sql?

1030

What are the sql commands?

1232

Is sql low level language?

1067

How delete a row in sql?

1043

What is pl sql architecture?

1006