select max(salary)from employees where salary

How to Remove the 3rd highest salary person record from
table?

Question Posted / avnish srivastava-test engg fc

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

Please Help Members By Posting Answers For Below Questions

What are the uses of Database Trigger ?

1708

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1928

What privilege is needed for a user to create tables in oracle?

950

Point out the difference between user tables and data dictionary?

978

How to use "if" statements on multiple conditions?

1166

How to connect to a remote server?

1120

What is the difference between sharding and replication?

1034

How to define an external table with a text file?

1059

How to define an oracle sub procedure?

1136

What is a schema in oracle?

1010

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1982

What is a package ? What are the advantages of package ?

1085

What is the database name in oracle?

1018

How to create a stored program unit?

1216

How to create a server parameter file?

1133