how to find the second highest salary from emp table?

Answer Posted / gunjal ghagre

Select sal from table_name order by sal desc limit 1,1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a native sql query?

499


What is the source code of a program?

514


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

599


Which software is used for pl sql programming?

526


What is sql exception?

520






what is schema? : Sql dba

564


How does pl sql work?

529


What is the plv (pl/vision) package offers?

619


Explain scalar functions in sql?

587


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

554


Why join is faster than subquery?

603


what is meant by urlencode and urldocode? : Sql dba

603


Can ddl statements be used in pl/sql?

598


What is difference between inner join and cross join?

522


How to return an array from java to pl/sql?

595