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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi friends ,, i will give a small advice for all of ,, pls send genune answering don,t send half knowladge answers pls pls pls ....... i faced so many problms in interview pannels so pls pls

1898


HI to all this is dinakar i am planning to write istqb foundation level exam but i dont have the material so any one have material regards that one please send to my id was dinakarmails@gmail.com thanks alot in advance

1935


What is parameter?

1036


What is boundary value testing?

1081


How will you define a critical bug?

1167


What is user documentation?

1012


What is software risk?

992


Mention the difference between data driven testing and retesting?

1035


What is functional specification?

1140


When should 'regression testing' be performed?

1068


What is storage virtualization?

2049


What is disaster recovery testing?

1015


what r the strategies & methodologies r u following in preperation of test cases based on usecase?

2081


Explain code inspection?

1130


'This life cycle model is driven by schedule and budget risks' this statement is best suited for.

1064