Answer Posted / aarti verma

get the 3rd highest salary:

SELECT DISTINCT salary from employee e ORDER BY salary DESC
LIMIT 2,1;

get the records of employees having 3rd highest salary:

SELECT * FROM employees WHERE salary = (SELECT DISTINCT
salary from employee e ORDER BY salary DESC LIMIT 2,1);

How to look at the current sql*plus system settings?

1082

---

What is sql deadlock?

1050

---

What is embedded sql what are its advantages?

962

---

What is the use of index in hive?

963

---

How do I run sql?

1096

---

how would you enter characters as hex numbers? : Sql dba

939

---

Why do we use sql constraints?

1124

---

Define concurrency control. : Transact sql

1105

---

Explain correlated query work?

992

---

What is basic structure of pl sql?

990

---

What is group function in sql?

966

---

What are the different types of tables in sql?

931

---

what is the difference between group by and order by in sql? : Sql dba

1061

---

What are reports usually used for?

968

---

Does truncate table reset auto increment?

941

---