Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 29617 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 to get @@error and @@rowcount at the same time? : Sql dba
Can we use pl sql in mysql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is synchronized subquery?
How delete all data from table in sql?
What is difference between nchar and nvarchar?
What is set transaction?
What is clustered and nonclustered index in sql?
What is insert command in sql?
Why we use join in sql?
what is a database lock ? : Sql dba
How to select 10 records from a table?
what are the features and advantages of object-oriented programming? : Sql dba
Show the two pl/sql cursor exceptions.
What is benefit of creating memory optimized table?
