Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What are the native operators of Datastage? (ETL Tool)

1 Answers   Cognizant,


Please send me the materials for ISTQB certification. My email ID is testdir@yahoo.com. Thanks in advance. Am specifically looking for The book: Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback) by PhD, CTFL John A. Estrella (Author), BSc, CTFL Maria C.Estrella (Author) ISBN-13: 978-1425131333

0 Answers  


Write a function Occurrences() in a language of your choice that takes in two strings. The first is a search string, and the second is a sentence. For example, running the function: Running Occurrences ("o", "Red Gate Software - Ingeniously Simple Tools") will output: Occurrences of 'o': 4 Occurrences ("at", "The cat sat on the mat") will output: Occurrences of 'at': 3 Sample Question 2: 2)Below is Notepad's File/Save dialog. a) If you were asked to test this dialog, how would you go about it? b) List various inputs you might place into the "File name" text field to test it.

0 Answers  


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

4 Answers   Accenture, Disha Tech, Verisoft,


Hi, For the web application testing, whether we can use "Acunetix Web Vulnerability Scanner", I want to know in detail. Thanks in advance bye

0 Answers  


What is pdr - peer design review?

0 Answers  


hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq

0 Answers   HCL,


What is the difference between functional test type and navigation test type?

3 Answers   Value Labs,


What is the meaning and purpose of each of: 1) Test Strategy 2) Test Plan #) Test Case? What is an example of each?

0 Answers  


Mention what the meaning of breath testing is?

0 Answers  


hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

0 Answers  


Explain cause-effect graphing?

0 Answers  


Categories