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

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.

Question Posted / kishore kumar

2 Answers
5787 Views
HealthTech, I also Faced
E-Mail Answers

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 race condition?

1133

Mention what the basic components of defect report format are?

1062

What is policy?

1089

What is oo integration testing?

1044

What r all the resources u need 4 the project u r currently in?

2265

Explain audit?

1058

What is memory leaks and buffer overflows ?

1168

what are all the folders maintained in memory location?

2218

Does anyone have best practices for daily backup &restore process for qc 11 ?

2260

What is coverage analysis?

1157

Iam searching for job on testing with 2+ experience any sites are there for testing jobs and any reference forward mee....mail.id: rakeshreddi50@gmail.com

1978

Explain smoke testing?

1075

What is exhaustive testing?

1112

Explain what is 'test plan driven' or 'key word driven' method of testing?

1379

What is the step you would follow once you find the defect?

1542