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 do you understand by case manipulation functions?

0 Answers  

---

What are schema-level triggers?

0 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

Can we insert in view in sql?

0 Answers  

---

how to enter numeric values as hex numbers? : Sql dba

0 Answers  

---

What are properties of the transaction?

0 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

Is sql a scripting language?

0 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---