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

options available in sequence job to run,validate?

1317


How do y read Sequential file from job control?

15960


why do u need the IOS upgradation in a FC switch

2282


What are sequencers?

1115


Name the different sorting methods in datastage.

1050


What is the flow of loading data into fact & dimensional tables?

1062


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

1255


How to implement complex jobs in data stage?

1112


What can we do with datastage director?

1238


What are data elements?

1173


how many rows sorted in sort stage by default in server jobs

3997


Can you implement SCD2 using join, transformer and funnel stage?

1557


Could anyone give brief explanation bout datastage admin

2352


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

1116


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2233