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 are triggers and its uses?

1093

---

How to write a query to show the details of a student from students table whose

1059

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1016

---

Do we need to rebuild index after truncate?

1095

---

What is scalar data type in pl sql?

1113

---

Can dml statements be used in pl/sql?

1121

---

What is clustered and nonclustered index in sql?

985

---

Show the cursor attributes of pl/sql.

1097

---

Can triggers stop a dml statement from executing on a table?

1155

---

How does sql profiler work?

1065

---

How do we accept inputs from user during runtime?

1116

---

What is normalisation in sql?

1098

---

What is sql server and ase?

1066

---

Is nosql faster than sql?

1071

---

What is the difference between partitioning and sharding?

1048

---