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 give the description of stages of SDLC.And what is feasibility study...?
What is “FRAG” related to Gaming
Explain how you would allocate a task to team members?
What is the difference between functional test type and navigation test type?
What are the various steps you will follow for the defect prevention? What is the procedure?
What the main advantages of statement coverage metric of software testing are?
what is SEI?
What is a system administrator?
Hi All, I am new this site also new to testing Domain, I am BSc (CS) Student 2010 passed out. I am planning to do Testing Course, some of them suggesting QAI Certificate Course. Could any one suggest is these certificate will useful to get the Job ? or QAI sitable for whom ? Thanks Saran
A number of critical bugs are fixed in software. All the bugs are in one module, related to reports. The test manager decides to do regression testing only on the reports module.
hello frnz when we r testing cookies for security testing in that we have to check for deleting cookies my ques is do we have to delete from browser(google chrome m using) or from hard drive? reply soon thanx
What is the maximum length of the test case we can write?