Answer Posted / bhanu yadav

For Nth Max.

select distinct a.sal from emp a where &N= (select count
(distinct b.sal) from emp b where b.sal>=a.sal)

For Nth Min.

select distinct a.sal from emp a where &N= (select count
(distinct b.sal) from emp b where b.sal<=a.sal)

How to see the table columns used in an index?

974

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1076

---

How to delete all rows a table in oracle?

1026

---

How to use regular expression in pattern match conditions in oracle?

983

---

How can we view last record added to a table?

978

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2584

---

How to shutdown your 10g xe server from command line?

1027

---

How to return top 5 rows in oracle?

1006

---

What is the implicit cursor in oracle?

1050

---

How a database is related to tablespaces?

995

---

Can we insert data in view oracle?

977

---

How can windows applications connect to oracle servers?

1002

---

Explain oracle’s server parameter file.

957

---

How to load data through external tables?

1085

---

Whats the benefit of dbms_stats over analyze?

1954

---