How to Remove the 3rd highest salary person record from
table?
Answer Posted / avnish srivastava-test engg fc
select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))
Is This Answer Correct ? | 10 Yes | 11 No |
Post New Answer View All Answers
How to get the Installed Oracle Version Information ?
How to check your oracle database 10g xe installation?
How data locks are respected in oracle?
How to loop through a cursor variable?
How to convert character types to numeric types?
What do you know about normalization? Explain in detail?
What do database buffers contain?
How do I connect to oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to use group functions in the select clause using oracle?
Explain the use of tables option in exp command.
What is object data modeling?
What is varray?
How to change system global area (sga) in oracle?
What is the quickest way to export a table to a flat file?