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

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2443


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2819


What are datastage sequences?

1056


How many Key we can define in remove duplicate stage?

1309


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2402


What is usage analysis in datastage?

1261


What are the types of views in datastage director?

1718


What is size of a transaction and an array means in a datastage?

1234


what is the difference between == and eq in UNIX shell scripting?

1417


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

1495


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3604


What is the difference between account and directory options ?

1109


Notification Activity

1345


How a source file is populated?

1015


Explain datastage architecture?

1332