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
What are the uses of Database Trigger ?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What privilege is needed for a user to create tables in oracle?
Point out the difference between user tables and data dictionary?
How to use "if" statements on multiple conditions?
How to connect to a remote server?
What is the difference between sharding and replication?
How to define an external table with a text file?
How to define an oracle sub procedure?
What is a schema in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is a package ? What are the advantages of package ?
What is the database name in oracle?
How to create a stored program unit?
How to create a server parameter file?