Answer Posted / monika

Select salary from emp order by salary desc LIMIT 1,1;

Is sql considered coding?

1043

---

Is pl sql a programming language?

981

---

Can we perform dml in function?

1063

---

What does where 1/2 mean in sql?

1062

---

what are the difference between clustered and a non-clustered index? : Sql dba

1030

---

What is record in pl sql?

1079

---

What are the 3 modes of parameter?

1151

---

What is the difference between alter trigger and drop trigger statements?

1099

---

What is the use of double ampersand (&&) in sql queries? Give an example

1138

---

How to find 3rd highest salary of an employee from the employee table in sql?

1079

---

What makes a good primary key?

1032

---

What is online transaction processing (oltp)?

1015

---

List and explain the different types of join clauses supported in ansi-standard sql?

1352

---

What is difference between primary and secondary key?

1022

---

What is parallel hint?

1315

---