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
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 |
Answer / kishore kumar
select * from table name where rownum in (1,3,10);
| Is This Answer Correct ? | 2 Yes | 0 No |
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams
Is it true that we can do system testing at any stage?
how do you test the server response time? do you use any tool? if so what tool ? if not how can you it be done manually ?
Explain what is testing type and what are the commonly used testing type?
I am having 1.5 years of exp. in Manual testing.What I have to do now? Should I do ISTQB Certification or Perl/Shell Scripting Languages? OR Anything else.Please Guide me properly.
Why can be tester dependent on configuration management?
Hi can any one please tell me about firmware testing and test harness please
What is the bottom-up approach?
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
What is v- diagram (model)?
I'm in search of a test management system that can handle the tasks for instance of a manager or a tester equally well Can anyone help you in this?