Answer / ajit

Select Rn, ename
  From ( Select Rownum rn, Ename
           From Emp
        ) 
  Where Rn = Nth;

Answer / prasad

Please give Fast

Answer / nannesaheb chinthalacheruvu

Question is not clear..kindly elaborate the same.

As i understand is "Retrive the single row with out using the where clause"...if so the below query may help you to achive the same.

Select e.*,max(rowid) from emp e;

select e.*,min(rowid) from emp e;

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

Is sql a scripting language?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

What is the file extension for sql database?

0 Answers  

---

what is the forward decleration in packages?

1 Answers  

---

How can we optimize a sql query?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What are triggers and its types?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

Is progress software supports to ( pl/sql )?

0 Answers  

---