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

test scenarios for downloading a file

1644


Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis

1622


Examples where you have worked on your own and as part of a team.

1710


Hi, Can any one please provide any links regarding the interview questions for Computer Systems Validation. I have got QA background and looking for a career in CSV in Pharmaceutical Companies. Thanks in advance...

1553


Can you test a program and find 100% of the errors?

570






Explain branch testing?

572


What is the main goal of defect prevention meeting?

559


What is criticality?

578


what is the main purpose of informal review

874


What is the main objective when reviewing a software deliverable?

798


i want learn "itesting tool"....which is best institutes to learn "itesting tool" in hyderabad or banglore ?plz give me reply as soon as posible?

1558


18). explain testing process in your organization? 19). are you participated in test plan preparation? 20). how will you prepare test cases? 21). explain importance of the priority in test case documents? 22). explain test execution process? 23). how much time will you take to write one test case? 24). how many test cases you can execute in a day? 25). explain bug life cycle? explain difference between seveority & priority?

1460


I got an offer from TCS as a software engineer, But it says I will work for TCS BPO, Is there any difference in policies of TCS BPO and TCS-IT Services.How is the Working enviornment and appriasal procedure

1674


What is class level methods?

557


What type of review requires formal entry and exit criteria, including metrics?

1106