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

Explain how a source file is populated?

1359


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1869


How do y read Sequential file from job control?

15943


what is ds administrator used for?

1164


Is possible to create skid in dim,fact tables?

2634


Differentiate between hash file and sequential file?

1066


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

2054


How do you reject records in a transformer?

1118


What are iconv and oconv?

1237


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644


Highlight the main features of datastage?

1155


sed,awk,head

1459


What is the difference between orabulk and bcp stages?

1021


What is ibm datastage flow designer?

1141


what is 'reconsideration error' and how can i respond to this error and how to debug this

2621