1. Categories >> Software >> Testing >> Testing AllOther
  2. Suggest New Category

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.

Question Posted / manoj

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

What is test tools?

0 Answers  

Hi, I attended an interview recently. I was asked the following question Assuming that I am Test Manager. There are 20 resources out of which 12 are manual testers, 5 automation testers and 3 performance testers. There are a bunch of projects to be tested in the organisation, the projects belong to various technologies, say 20% of projects in Java, 20% of projects in SAP, 30% of projects in .NET, 30% of projects in C# What is your approach as Test Manager in testing? Pls let me know your approach on this.

6 Answers   CTS,

I am planning to write ISTQB Foundation level certification. If you have materials/Q&Q, kindly send to me. My mail id:jyoti.akella@gmail.com .Pls help me

4 Answers  

is there any open source testing tool to perform whitebox testing and black box testing which supports c++ in linux.plz ans

1 Answers   CTS, Infosys, Satyam, Sonata, Wipro,

What is a system administrator?

0 Answers  




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

0 Answers  

What are the main key components in Web applications and client and Server applications? (differences)

4 Answers   Accenture, Disha Tech, Verisoft,

What is service pack..what is the purpose of this..?This question was asked in an testing interview..that's why i posted this in this category..

1 Answers   Infeneon Technologies,

Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

0 Answers  

What is storage virtualization?

0 Answers  

What is PMRS?

1 Answers  

Plz can u explain any issues in ur current project? what type of issues occured?

1 Answers  

For more Testing AllOther Interview Questions Click Here
Categories