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

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Answer Posted / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the components of workflow manager?

1110


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1138


Explain what transformation and how many are there in informatica?

964


What is the session task and command task?

1069


What happens when a session fails and you click on recover?

1126


Why sorter is an active transformation?

1206


what is degenerated dimension?

4012


what is Active lock explain

2811


How can we use mapping variables in informatica? Where do we use them?

1214


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1074


Differentiate between a database and data warehouse?

1155


Write the different tools in the workflow manager?

1078


Have you worked with/created Parameter file

1669


Clarify the utilization of aggregator cache record?

1013


How to create the source and target database connections in server manager?

1102