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

how to do backup entire database? : Transact sql

1191

---

What is audit logout in sql profiler?

1073

---

How do I tune a sql query?

1034

---

What is database migration?

1008

---

How to sort the rows in sql.

1117

---

What are expressions?

1060

---

What does sign mean sql?

1177

---

How delete all data from all tables in sql?

982

---

Can we use pl sql in sql server?

1131

---

What are the set operators in sql?

1132

---

How many sql databases can you have on one server?

1150

---

List the various privileges that a user can grant to another user?

1088

---

What is record type in pl sql?

1032

---

What is the cause of mutating table error and how can we solve it?

1097

---

What is nvarchar max in sql?

1072

---