Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 29292 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
SELECT EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;
---------------------------------------------
(This is easy method to find nth record from a table).....
| Is This Answer Correct ? | 30 Yes | 5 No |
Post New Answer View All Answers
how many sql dml commands are supported by 'mysql'? : Sql dba
What does bitemporal mean?
What is the difference between nested table and varray?
what is row? : Sql dba
What is pivot in sql?
Explain the working of foreign key?
What are the topics in pl sql?
Why is a primary key important?
What is the difference between a subquery and a join?
What are the types of records?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What does joining a thread mean?
how to shut down the server with 'mysqladmin'? : Sql dba
What is the purpose of normalization?
What are the qualities of 2nf?
