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

project Steps,hits, Project level HArd things,Solved methods?

2123


What are the processing stages?

1095


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644


How we can covert server job to a parallel job?

1136


root tree will find which is server job and which is parallel job?

1963


What is the difference between hashfile and sequential file?

1252


What are the types of hashed files in data stage

1106


why do u need the IOS upgradation in a FC switch

2277


how to delete one row in target dataset

3112


What is the importance of the exception activity in datastage?

1064


What are constraints and derivations?

1164


On which Dimension Table you implemented SCD Type in your Project

2024


whom do you report?

1921


How can we improve the performance in datastage?

1097


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

2718