Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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.

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

With the help of Bug Id how will u find in which module or in which test case a bug hv been arised... ie hw will u track down the bug.....

4 Answers  


what is modular framework?

0 Answers   HCL,


Find odd man out related to EA a) Play fish b) Take2 c) Hasbro d) Pogo

8 Answers   EA Electronic Arts,


How will you define a critical bug?

0 Answers  


Explain cause-effect graphing?

0 Answers  






Will you write a test plan in all phases?

11 Answers   Accenture, HCL,


Have you performed tests on the front-end and the back-end?

0 Answers  


I would like to know whether Zephyr, the test management tool takes a complex installation procedure.

1 Answers  


To test a function, what has to write a programmer, which calls the function to be tested and pass test data.

0 Answers  


What is boundary value?

0 Answers  


Hi I am newly joined this forum.I am from Uk coming to hyderabad for 8 weeks for Software Testing Course.Please advice me the best Institute. Eagerly waiting for your response ASAP.

4 Answers  


Explain what it means by test harness?

0 Answers  






Categories