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
What is a native sql query?
What is the source code of a program?
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?
Which software is used for pl sql programming?
What is sql exception?
what is schema? : Sql dba
How does pl sql work?
What is the plv (pl/vision) package offers?
Explain scalar functions in sql?
how to create a new table in mysql? : Sql dba
Why join is faster than subquery?
what is meant by urlencode and urldocode? : Sql dba
Can ddl statements be used in pl/sql?
What is difference between inner join and cross join?
How to return an array from java to pl/sql?