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
Are These Dff's Flexible?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the difference between recovery and restoring of the oracle database?
What is Tax Categories?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
how to replace not in with not exist?
Explain about party and customer in ar : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is an Oracle database Partial Backup?
what are the API of GL,PO,AP
What is Restricted Mode of Instance Startup in Oracle?
key flexfield structure
What is auto invoicing? : oracle accounts receivable
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?