how u can find the n row from a table?
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
Are there any features that are decommissioned in 11g that are not present in 11g?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is the use of index in hive?
Which join condition can be specified using on clause?
What is the difference between a primary key and a clustered index?
Can we use insert statement in function?
Which sql most popular?
what is the difference between delete and truncate commands? : Sql dba
Are null values same as that of zero or a blank space?
What is the difference between inner join and natural join?
What are the advantages of pl sql over sql?
What is a procedure in pl sql?
Explain about various levels of constraint.
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is nosql vs sql?