Answer Posted / srijith pillai

This will give you third highest salary

select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;

How many parts of a pl sql block are optional?

1135

---

What are the sql aggregate functions?

1134

---

What is sql exception?

975

---

Why we use join in sql?

977

---

How to place comments in pl/sql?

1159

---

What is the current version of postgresql?

1067

---

What is full join in sql?

993

---

How do I create a memory optimized filegroup?

963

---

What is application trigger?

1001

---

What is a schema sql?

1157

---

what are the security recommendations while using mysql? : Sql dba

1119

---

How sql query is executed?

1133

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

---

What types of commands can be executed in sql*plus?

1109

---

What are sql ddl commands?

1093

---