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...

write a query to display the third record from the employee
table?

Answer Posted / i.anil

select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create measures and dimensions?

1129


what is requery in cognos?

2487


What do you mean by query studio?

950


Write some methods to apply securities in framework manager model?

1123


what is the difference between querystudio in reportnet and cognos8

2139


What is the difference between the standard and metrics folder?

974


What is cognos reporting tool?

1098


What is the enterprise class platform architecture of cognos 8?

1031


What is the difference between a cascading report and drill through the report?

1175


How to publish a package by running Java Script?

2092


What are the steps to import the two data sources in framework manager?

1049


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

2019


Define query studio?

1009


----------------Diff b/w Dimensional modeling and Relational modeling?

15014


Explain what is the difference between microstrategy and cognos reporting tool?

1079