how to select second mauximum value in a given table under salary column
Answer Posted / jai
SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
How do I spool to a csv formatted file using sqlplus?
What happens if you set the sga too low in oracle?
Can we create trigger on materialized view in oracle?
how to handle exceptions in post production
How to drop a stored procedure in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
How to resolve the ORA-39133 error in Oracle?
What's dateware house and what's clustor with practicle example
What is Virtual Private Database in Oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to create additional tablespaces for an new database?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Can you have more than one content canvas view attached with a window ?
What is instant client oracle?
How do you bind variables in oracle?