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
What is syntax?
What is memory leak and defect leak? Is there any harness testing? If yes, please explain?
What is a variant?
Explain the tasks of test closure activities.
What is FCOE?
hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq
What it means by test harness?
What does cots represent?
IF i have two columns in Database , While using Database output value ,allthe values in the two column are set as a single row in the QTP datatable, can u suggest me a idea so that QTP Runtime datatable displays the values as it is in the database
What the difference between latent and masked defects is?
Explain the difference between functional and structural testing.
i am a PG science(chemistry),now am working test engineer in small organization,now i will decide to move better organization please send model cv and advises
What is control chart?
Can any of u help me... How to use Security below listed testing tools 1. XSS Probe 2. SQL Power Injector 3. CAL9000 I have to do security testing using these tools.But I do not have any knowlwdge on this. I am trying to work using Help doc, but use, not able to follow Pls do needful
What is heuristics testing?