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

How delete all data from all tables in sql?

690

---

What are the syntax and use of the coalesce function?

775

---

Can a foreign key have a different name?

695

---

What are two statement types in sql?

745

---

What are the sql commands?

792

---

---

What is rownum?

711

---

what are the limitations of identity column? : Transact sql

822

---

what is query cache in mysql? : Sql dba

766

---

What is sql engine in oracle?

723

---

Why is sharding used?

726

---

Is like operator in sql case sensitive?

734

---

How do you run a query?

768

---

How do I find duplicates in a single column in sql?

733

---

Explain character-manipulation functions?

838

---

What are views in sql?

721

---