write a querry .if 10 records in a table.i want only 1
record and 3 reocrd and 10 record. how to write a querry.

Answer Posted / kishore kumar

select * from table name where rownum in (1,3,10);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are two formats of WWN defined by the IEEE?

1556


What is test item?

562


What are the maximum no. of devices supported in SCS-1,2 and 3?

1417


In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?

593


Explain interface?

566






In a reactive approach to testing when would you expect the bulk of the test design work to be begun?

796


What the purpose behind doing end-to-end testing is?

533


wat r d schedules for testing?

2044


How will you conduct risk analysis?

653


What is the average size of executables that you have created?

797


Explain the requirements?

588


What would you say to your boss if he?s crazy about an idea, but you think it stinks?

2081


On what basis you can arrive at an estimation for your project?

547


What is test specification?

616


how do you convert use cases into test cases?

685