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 use distinct and count in sql query? Explain

999

---

What is the difference between Union and Union all. Which is faster.

1380

---

Which table is left in left join?

990

---

How to disable a trigger name update_salary?

1249

---

Can we use views in stored procedure?

1018

---

What is the use of double ampersand (&&) in sql queries? Give an example

1122

---

Which command is used to delete a package?

1148

---

Which query operators in sql is used for pattern matching?

940

---

What plvcmt and plvrb does in pl/sql?

1291

---

Can we use ddl statements in stored procedure?

1129

---

what is normalization? : Sql dba

1068

---

What are hotfixes and patches?

928

---

What does stand for in sql?

951

---

What is oracle pl sql developer?

963

---

Why do we need cursor in pl sql?

1119

---