Answer Posted / karna

Hi Friends,

sorry,last answer was wrong.
I have changed the query,check now

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 order by desc)

any queries,mail me at karun84@gmail.com

Is mariadb a nosql database?

1056

---

What is relationship? How many types of relationship are there?

1185

---

Are views faster than queries?

993

---

What is the difference between joins?

1045

---

How can you select unique records from a table?

1081

---

How do I count records in sql?

1014

---

write an sql query to find names of employee start with 'a'? : Sql dba

1028

---

What is a rank in sql?

968

---

Mention what does the hierarchical profiler does?

1093

---

what is 'mysqladmin' in mysql? : Sql dba

1026

---

Does a primary key have to be a number?

965

---

How to connect a sql*plus session to an oracle server?

1129

---

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

1022

---

How do I clear the screen in sql plus?

1047

---

Differentiate pl/sql and sql?

1071

---