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...

1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?

Answer Posted / subbu

2nd answer:

select * from(select rowid from tablename where rowid between 5 and 7);

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various kinds of the hash file?

1151


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295


To see hidden files in LINIX?

1530


What are transforms and what is the differenece between routines and transforms?

1066


what is the use of surogate key in datastage

2310


What is "fatal error/rdbms code 3996" error?

1268


How many Key we can define in remove duplicate stage?

1388


What is a folder? Difference types of stages?

1178


What are the job parameters?

1221


Define orabulk and bcp stages?

1123


What is difference between join, merge and lookup stage?

1099


Define Merge?

1320


What is the difference between passive stage and active stage?

1539


How do you run datastage job from the command line?

1093