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

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1554


What is ds designer?

1159


What are the repository tables in datastage?

1348


How do you import and export data into datastage?

1291


Is the value of staging variable stored temporarily or permanently?

1051


What are the types of views in datastage director?

1823


If you want to use the same piece of code in different jobs, how will you achieve it?

1214


How many types of stage?

1224


How do you import and export the datastage jobs?

1207


What are the functionalities of link partitioner?

1063


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3398


What are the types of containers and how to create them?

1020


How you can fix the truncated data error in datastage?

1877


Differentiate between datastage and informatica?

1244


What are the components of ascential data stage?

1240