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 declare a local variable?
What is a oracle database?
Explain about integrity constraint?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
When system tablespace is created?
What is raw datatype in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What do you understand by database schema and what does it hold?
Is there any function in oracle similar like group_concat of mysql?
How to get execution statistics reports on query statements?
What is a trace file and how is it created in oracle?
What is meant by recursive hints in oracle?
Explain the truncate in oracle?
What do you mean by cdb and pdb in oracle 12c?
Write a trigger example in oracle?