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

What are the different options associated with dsjob command?

1382


What is a merge in datastage?

1211


Triggers,VIEW,Procedures

1185


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3221


How can we improve the performance in datastage?

1068


What are the enhancements made in datastage 7.5 compare with 7.0?

1104


how do u catch bad rows from OCI stage? And what CLI stands for?

2758


Is possible to create skid in dim,fact tables?

2593


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

2685


To see hidden files in LINIX?

1465


what is the use of surogate key in datastage

2264


What is merge stage?

1238


table actions available in oracle connector?

1565


What is a quality stage in datastage tool?

1034


What are the features of datastage flow designer?

1000