write the sql query to display 5th and 10th row in a table?

Answer Posted / lakshmi reddy

select * from(select emp.*,rownum r from emp) where r=5 or r=10

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1495


What is set to be cardinality?

638


what is the difference between querystudio in reportnet and cognos8

1735


What is the importance of having monitor service in cognos?

580


what is the procedure for scheduling conditional rendering?

2004






Explain the different types of views used in cognos.

506


Explain what is the difference between microstrategy and cognos reporting tool?

541


What is the report studio?

598


What is meant by alternate drill down with ex?

624


how to explain health care project and which reports we can create in health care doain?

6354


------------------What is Inline Query?

1792


What are the methods by which it non-durable model could be changed into the durable model?

522


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

557


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

1571


Write various indexes used in cognos?

556