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

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2246


How you can fix the truncated data error in datastage?

1711


What is aggtorec restructure operator?

1387


What are system variables and sequencers in datastage

1084


Explain entity, attribute and relationship in datastage?

1066


In Datastage, how you can fix the truncated data error?

1118


Explain usage analysis in datastage?

1123


What is staging variable?

1048


Describe stream connector?

1266


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2426


Explain connectivity between datastage with datasources?

955


How to perform incremental load in datastage?

1155


What is the difference between server job and parallel jobs?

1108


What is a datastage job?

992


whom do you report?

1897