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

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 / manoj

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

Answers were Sorted based on User's Feedback

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

Answer / sreelatha reddy

suppose you have 10 records in a table.First i will explain
about the structure of the table.

emp Table
Sno sname ssal scommm
1 aaa 3000 400
2 bbb 4000 500
3 ccc 5000 500
4 ddd 6000 600
-
-
-
-
-
10 zzz 8000 800

select * from emp where sno in(1,3,10);

Is This Answer Correct ?

2 Yes

0 No

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

Answer / kishore kumar

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Testing AllOther Interview Questions

Why can be tester dependent on configuration management?

0 Answers MCN Solutions,

If the client identified some bugs to whom did he reported?

1 Answers TCS,

I have took training in software testing and I don't have much experience before going to start my career I want to get knowledge on testing...please suggest.

2 Answers

write a script to extract LIKE word from the sentence I LIKE Flowers

1 Answers HealthAsyst,

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

0 Answers

Explain beta testing?

0 Answers

In which phase should testing begin – requirements, planning, design, or coding?

0 Answers

hai dis is lavanya... i want to do certification in testing. what are the names of the books tat i have to refer for the certification...

3 Answers

How would you estimate the amount of re-testing likely to be required?