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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kishore kumar
select * from table name where rownum in (1,3,10);
| Is This Answer Correct ? | 2 Yes | 0 No |
What do enterprises do for QC 11 to prevent minimum data loss ?
Explain inputs?
What are the best practices for software quality assurance?
When is rtm (requirement traceability matrix) prepared?
What is meant by Traceability Matrix?
2 Answers Cap Gemini, CarrizalSoft Technologies, IBM,
Draw the Framework Architecture of Selenium RC with combination of Selenium webdriver?
What is supplier?
repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component:
What are the layers of iSCSI Protocol?
If you had 10 days to deliver the product but the Lead tells to deliver it in 6 days, then How and what Testing Techniques or Strategy you will follow inorder to deliver it in short time (6 days)
Hey friends...mail me interview questions of manual testing.. Give me explanation of Automated Tools quality center on my gmail mca.rachna21@gmail.com quick test profession load runner
What are non-functional requirements?