Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / lakshminarayana reddy
select rownum,empno,ename,job,sal from emp(select
rownum,empno,ename,job,sal from emp order by sal desc) grop
by rownum,empno,ename,job,sal having rownum=2;
Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
What are triggers in sql?
What is the maximum number of columns in sql table?
How do you create a unique index?
What is mdf ldf and ndf?
What is difference between sql and oracle?
Why do we use joins?
What is a boolean in sql?
What are the query optimization techniques?
what is msql? : Sql dba
What are the two parts of design view?
What is the difference between the conventional and direct path loader? : aql loader
How do I get sql certification?
What is a design view?
Explain the uses of control file.
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.