how u can find the n row from a table?
Answer Posted / vijayshanker
SELECT EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to enter binary numbers in sql statements? : Sql dba
Is mariadb nosql?
Does mysql support pl sql?
What is normalisation in sql?
What are the different type of joins in sql?
What is the purpose of my sql?
What are secondary keys?
What is a parameter query?
How to fix oracle error ora-00942: table or view does not exist
What is clustered index in sql?
What is audit logout in sql profiler?
Is pl sql still used?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How to use sql*plus built-in timers?
What are the various levels of constraints?