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

2nd answer:

select * from(select rowid from tablename where rowid between 5 and 7);

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2380


How many types of sorting methods are available in datastage?

1067


how to add a new records into source?

1996


Why do we use exception activity in Datastage?

1305


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2275


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3789


How you Implemented SCD Type 1 & Type 2 in your project?

4125


What are the some differences between 7.x and 8.x version of datastage?

1253


What are the repository tables in datastage?

1301


What is the difference between account and directory options ?

1176


Can you define merge?

1116


Difference between data warehousing and olap?

1089


Explain ibm infosphere information server and highlight its main features?

1085


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


What are the different common services in datastage?

1277