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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which types are testing are important for web testing?

639


What is api (application programming interface)?

607


In real time how you do the soak testing?

544


What is difference between known regression testing and unknown regression testing?

609


Mention what the difference between a 'defect' and a 'failure' in software testing is?

610






List the comparison between FC and FCOE?

1871


What is path analysis?

816


Explain static analysis?

597


What is vdd - version description document?

591


please suggest me some topics for research in software testing/software reliability......

1501


What is test executive?

602


Explain smoke testing?

565


what is the main purpose of informal review

882


what is the meaning of Field Level Validation & Form Level Validation??

2056


Explain what test plan is? What is the information that should be covered in test plan?

595