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



write a querry .if 10 records in a table.i want only 1 record and 3 reocrd and 10 record. how to w..

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

write a querry .if 10 records in a table.i want only 1 record and 3 reocrd and 10 record. how to w..

Answer / kishore kumar

select * from table name where rownum in (1,3,10);

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Testing AllOther Interview Questions

could u tell me from where could i get material for ISTQB foundation level exam..and how can I prepare for that..my mail id ghoshbandana@yahoo.com

2 Answers  


What is problem?

0 Answers  


what is TRM?

3 Answers   MBT,


what is the actual time to stop testing a product.

2 Answers  


What is the difference between QC 10.0 and ALM 11.5? Whether ALM is any upgradation to QC? 

1 Answers   HCL,






why is waterfall model not good?

0 Answers   Impetus,


What is Application entry and exit criteria

3 Answers   Maveric,


What is white box testing and list the types of white box testing?

0 Answers  


Explain metric?

0 Answers  


What is test incident report?

0 Answers  


What is equivalence partitioning?

0 Answers  


Demonstrated system testing experience in a large on-line environment – with at least 2 years experience including Development of test strategies development of test plans • execution of tests according to plans • defect management • using industry tools (eg HP Quality Centre formerly 'Mercury Quality Centre' (Test Director) , and • experience in interrogating and querying SQL server and Mainframe dtabases using tools such as RC Update, BRIO, SQL Server Management Studio

0 Answers  


Categories