Answer Posted / sreekanth

SELECT MIN(SAL)
FROM(SELECT distinct SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where N is the Nth highest salary u want

What is clause?

1067

---

How can a function retun more than one value in oracle with proper example?

1029

---

What is where clause in sql?

984

---

What will you get by the cursor attribute sql%rowcount?

974

---

What are sql built in functions?

896

---

Explain ttitle and btitle.

1058

---

Can we use commit inside a trigger?

1030

---

how to concatenate two character strings? : Sql dba

1033

---

What is pl sql package?

993

---

Is sql workbench free?

932

---

What is the maximum rows in csv?

860

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

---

How do I debug a stored procedure?

1042

---

what is a record in a database ? : Sql dba

997

---

explain the difference between bool, tinyint and bit. : Sql dba

939

---