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 dynamic testing?
Explain performance testing?
give an example of unit test and integration test and system test and UAT test?
What is the dfd (data flow diagram)?
What is a user friendly document?
When is a test considered to be successful?
What good bug tracking systems have you used?
Explain test plan?
What is a test harness?
How we will do DataBase testing through Qtp application, i know two things 1)Import date from sheet2)Database Check points. But Interviewr asked me How to Run Queries from Qtp Application?Plz Any Body Exlain about Data Base Testing.Urgent.........Advanced Thanks
Explain test driver?
What is the maximum length of cable supported in SCS-1,2 and 3?
Which is the current formal world-wide recognized documentation standard?
When is used decision table testing?
What is quality matrix in software testing?