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

what are the different type of sql's statements ? : Sql dba

874

---

What is the difference between left and left outer join?

895

---

List the ways to get the count of records in a table?

853

---

What is the difference between inner join and left join?

939

---

What is rownum?

924

---

Explain the the delete statements in sql?

982

---

What does an inner join do?

1093

---

how can we know the count/number of elements of an array? : Sql dba

1007

---

What is trigger explain it?

966

---

What does desc stand for?

1022

---

what are ddl statements in mysql? : Sql dba

1114

---

What is group by in sql?

1027

---

What is the difference between clustered and non-clustered index in sql?

959

---

Which is better varchar or nvarchar?

934

---

What is a stored procedure in sql with example?

1058

---