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 test script?
Hi Guy's Pls. go to Forum of Allinterview.com for Testing Job Openings..You can find various job openings in Forum. You can submit ur resume too
What are the maximum no. of devices supported in SCS-1,2 and 3?
Explain software testing strategies?
what should be analyzed in laod testing?
What is the benefit of test independence?
hi Can anyone explain how to use sql quries in database testing with a real time scenarioin an application
plz give me any body some 3top UAT test cases, Advance thanks?
On what basis you can arrive at an estimation for your project?
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
What is syntax?
why we split testing into distinct stages?
Every One is saying that Documentation is very very importent in Tester's Life.Could any one explain with proper examples..?
have u write any sanity testcases?
What is validation and verification testing?