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

what is the querry to get first 10 records from the emp
table?(emp no is the primary key)

Answer Posted / karthik

select * from emp
where rownum <=10;

or

select * from (select rownum r,emp.* from emp)
where
r between 1 and 10;

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297


Explain the process of recievables in oracle financials. : oracle accounts receivable

1155


Difference between negative and positive adjustments : oracle accounts receivable

1104


What is auto invoicing? Explain : oracle accounts receivable

1126


where the dff data will be stored

2439


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2186


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1280


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2327


Explain prerequisites and post activities of oracle database installation

2132


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1172


Where in the Oracle directory tree structure are audit traces placed?

2638


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2399


HOW TO SPOT AHIERARCHY?

2295


what are the API of GL,PO,AP

2267


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2023