i need query for displaying the eno,ename in a table from row 2 to row 5

i need query for displaying the eno,ename in a table from row
2 to row 5

Question Posted / guest

1 Answers
4193 Views
I also Faced
E-Mail Answers

i need query for displaying the eno,ename in a table from row 2 to row 5..

ans 1 -

select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5

------------------

we can also use row_number function

Is This Answer Correct ?

8 Yes

2 No

Post New Answer

More Database Management Interview Questions

What are the characteristics of dbms?

0 Answers

What is instance in dbms?

0 Answers

How do I add a file to a database?

0 Answers

What are the different types of keys in database?

0 Answers

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers

What is the structure of a database?

0 Answers

What are the four types of database?

0 Answers

What are the components of a database management system?

0 Answers

What is a degree of relation?

0 Answers

How do you create a blank database?

0 Answers

What is considered a database?

0 Answers

what is the difference between DBMS and RDBMS??

76 Answers Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS,

For more Database Management Interview Questions Click Here