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

What operators deal with null?

1107

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2170

---

What are tables in sql?

1066

---

What is sqlite used for?

1003

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

---

What is pl sql in oracle?

1044

---

Explain the difference between rename and alias?

1010

---

Explain table and field in sql?

1063

---

What is the sql case statement?

1008

---

Enlist the data types that can be used in pl/sql?

1073

---

what is union, minus and interact commands? : Sql dba

1186

---

Why having clause is used in sql?

979

---

How do I make my sql query run faster?

941

---

what is sub-query? : Transact sql

1106

---

What is cursor in pl sql with examples?

1034

---