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 is Test Server?
What is different Between Black boxtesting and functional testing...
what is testing , why will be testing ,what is responsibilities of tester
content of test status report
I'm interested to build my career in testing and I don't have much knowledge which book is good to refer. Can anybody please share some books names ?
What is eexception?
Explain inputs?
When you have logged a Defect for X, Y, Z issue. i)If X, Y issues are fixed and Z issue is not fixed. What will you do? ii)If X, Y, Z issues are fixed and a new issues T is created. What will you do?
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 a 'defect' and a 'failure' in software testing is?
When is rtm (requirement traceability matrix) prepared?
What advantages would using an iSCSI Storage Area Network (SAN) give to your organization over using Direct Attached Storage (DAS) or a Fibre Channel SAN?