Answer Posted / karna

Hi Friends,

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table)

any queries,mail me at karun84@gmail.com

Explain isolation levels. : Transact sql

1017

---

Name some usages of database trigger?

969

---

Where is all the data on the internet stored?

949

---

What is sql exception?

915

---

What do you mean by rowid?

917

---

What is sqlca in db2?

895

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

946

---

What are database links used for?

994

---

Why join is faster than subquery?

1049

---

What is sql lookup?

865

---

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

1384

---

What is trigger in sql and its types?

992

---

What is sql constant?

945

---

Show how functions and procedures are called in a pl/sql block.

1043

---

Explain the significance of the & and && operators in pl sql.

952

---