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 is CDB?

1501


How the 2 wings and body of the butterfly model of test development is represented?

596


1). explain need of software testing? 2). explain difference between developer testing & test engineers testing? 3). explain difference between verification & validation 4). which process your organization follows to develop an application? 5). explain v-model? & what is the meeting point in v-model?

2220


What is maintenance testing?

612


What is disaster recovery testing?

590






What type of review requires formal entry and exit criteria, including metrics?

1118


Functional testing?

558


Hi All!!Can anyone please suggest some better website to learn Mainframe Testing??Am very much new to Mainframes. Thanks in Advance Nithya

1214


What is storage testing?

729


In real time how you do the soak testing?

544


How much testing is enough?

642


Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

1513


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

812


What are the valuable steps to resolve issues while testing?

912


What is metric?

621