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 |
Here is a topic for me to give a seminar "Web and Window based Testing".I didnt understand,which testing this topic comes under.can you give clear information and ralted urls,so that it will help me a lot.
Where do you see yourself five years from now?
what is mean by sdlc & stlc? what is mean by V-model?
What is branch coverage?
IS TESTING NEEDED TO EACH&EVERY PROJECT CUMPULSORY OR NOT?
What is Six sigma? Explain.
What's Stress Testing?
What is path analysis?
How do the companies expect the defect reporting to be communicated by the tester to the development team. Can the excel sheet template be used for defect reporting. If so what are the common fields that are to be included who assigns the priority and severity of the defect.
How you will write test cases for integration testing?
What is difference between known regression testing and unknown regression testing?
Plz can u explain any issues in ur current project? what type of issues occured?