Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 30130 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
Is primary key clustered index?
How many postgresql users are there, worldwide?
What are the types of dbms?
How many tables can a sql database have?
What is dba in sql? : SQL DBA
What is normalization sql?
What is data profiling in sql?
What is embedded sql in db2?
What is integrity in sql?
What is sql table?
What are different methods to trace the pl/sql code?
what are the limitations of identity column? : Transact sql
What is the file extension for sql database?
In what condition is it good to disable a trigger?
What is sqlcontext?
