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 / segu satish

answer for 3rd question:

select * from emp where rowid =(select max(rowid) from emp)

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where the datastage stored his repository?

1089


Is the value of staging variable stored temporarily or permanently?

1004


what is the use of skid in reporting?

2381


How to read multiple files using a single datastage job if files have the same metadata?

1252


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1288


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814


How many types of stage?

1181


What is datastage?

1091


Can you filter data in hashed file?

3780


How and where you used hash file?

1176


What are datastage sequences?

1126


How do you import and export data into datastage?

1242


How can you write parallel routines in datastage PX?

1019


How a server job can be converted to a parallel job?

1096


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1233