A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answers were Sorted based on User's Feedback
Answer / laks
select * from emp where rownum<121
minus(select * from emp where rownum<101)
Is This Answer Correct ? | 34 Yes | 4 No |
Answer / swapna
select * from emp where rownum<121
minus (select * from empwhere rownum<100);
Is This Answer Correct ? | 11 Yes | 6 No |
Answer / d
select *
from (select rownum row_num
,tab.*
from table tab)
where row_num between 100 and 120
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / subhradeep
select * from employees where rownum<102
minus(select * from employees where rownum<81)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gourav josih
select *from employees
where employee_id between 120 and 150;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / nayana
select * from emp where rownum<121
minus(select * from emp where rownum<100)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arif hussain
select * from (
select ROW_NUMBER() over (order by tablename.columnname)as ronno,* from tablename )x
where ronno between 100 and 120
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mohan
select * from table_name where rownum between 100 and 120;
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / anjana
Select *,row_number over(partition by departmentid order by empid)as rowid from employeeDept
where rowid between 100 and 120
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srinivas
select * from(select <table_name>.*,rownum rn from <Table_name>) where rn between 100 and 120
Is This Answer Correct ? | 0 Yes | 0 No |
Is pl sql different from sql?
What is bitemporal narrowing?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
What is the difference between an inner join and an outer join?
Why are cursors used?
what the meaning of sql
What is meant by temporal data?
Where is pl sql used?
In a package if we have 10 procedures or functions,How to know which will execute first?
IF i write before / after insert / update trigger and i do rollback what will happen?
What can you do with pl sql?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy