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

When usin qtp iam able to get the data from the database only in a single row that is if i have 2 columns in database,when using database output value , all the values in Database are transfered to a single row in QTP datatable. I want the values to appear as it is from the database , can anyone suggest some ideas?

0 Answers  


Hi I would like to ask a general question, I finished my post graduation(arts)a long back say 2000. I have a diploma in IT. And I have completed a course in testing(2010). What are my chances of getting a job in testing. I really have an apitude for testing and if given an opputunity I will do well. But I have been sent away after apitude tests which I know I did well(3 or 4 might have gone wrong), hr rounds. Can u tell me if I will get a job at all. Really I feel very let down. Give suggestions that will work thanx

1 Answers  


What would you say to your boss if he?s crazy about an idea, but you think it stinks?

1 Answers  


how do you test the server response time? do you use any tool? if so what tool ? if not how can you it be done manually ?

1 Answers   Amdocs,


One diagram is given find out the diagram

1 Answers   EA Electronic Arts,


What is coverage analysis?

0 Answers  


What is brainstorming?

0 Answers  


what r the benifits of continuous testing?

1 Answers   MBT,


There are two sand clocks(timers) one complete totally in 7 minutes and other in 9-minutes we have to calculate with this timers and bang the bell after completion of 11- minutes!plz give me the solution.

6 Answers   Oracle,


Hi,Iam learning software testing now.i want to put 2+ yrs exp:.Is there any problem with fake exp:.how to prepair for the Interview. Thank u

1 Answers  


What it means by test harness?

0 Answers  


What is what are the parameters of performance testing?

0 Answers  


Categories