Answer Posted / maroju naveen

select level,max(sal) from emp where level=&levelno
connect by prior sal>sal
group by level;
This is Nth max(sal) query.....

What is the main reason behind using an index?

560

---

how can we find the number of rows in a table using mysql? : Sql dba

590

---

How do you explain an index number?

541

---

What are the 3 modes of parameter?

686

---

How to read xml file in oracle pl sql?

512

---

---

Is pl sql a programming language?

553

---

What is tuple in sql?

547

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

558

---

How do I make my sql query run faster?

470

---

What are the key differences between SQL and PL SQL?

630

---

What is cursor explain with example?

562

---

How many types of normalization are there?

493

---

how to get @@error and @@rowcount at the same time? : Sql dba

533

---

What is online transaction processing (oltp)?

605

---

What are procedures used for?

533

---