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 |
What is the difference between preventative and reactive approaches to testing?
When should configuration management procedures be implemented?
What is quality circle?
Explain basis path testing?
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
How will you recognise if a case is a 'test case'?
Non-functional system testing includes
IS TESTING NEEDED TO EACH&EVERY PROJECT CUMPULSORY OR NOT?
what you do when your reported defect rejected?
hi am fresher learning software testing so how will b interviw environment for fresher testers.On which topic i have to concentrate more(MANUAL r AUTOMATED)
What are the different tabs available in QC?
Explain how does a test coverage tool work?