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 / ravi

1 answere : we can use @rownum =1 and reject the first record....

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between hashfile and sequential file?

1311


Define oconv () and iconv () functions in datastage?

1462


What is the use of hoursfromtime() function in transformer stage in datastage?

1109


How rejected rows are managed in datastage?

1572


On which Dimension Table you implemented SCD Type in your Project

2109


Whats difference betweeen operational data stage (ods) and data warehouse?

1166


What are datastage sequences?

1166


What is use Array size in datastage

1821


Describe the architecture of datastage?

1060


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

1103


What is the difference between Datastage 7.5 and 7.0?

1148


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3179


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2261


What are the various kinds of containers available in datastage?

1100


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2109