Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8103 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / g.arangarasu
No friends,
rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.
we can retrieve this record through physical location that
is using rowid not rownum.
select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to explain health care project and which reports we can create in health care doain?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
----------------Describe DWH Architecture?
What are the components used in web tier?
what is the difference between filter and condition?
How we check the errors before running the report?
Can you define report item?
Can you define metrics designer?
What is difference between content store and content manager?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
1. Explain your project.
How can I schedule reports in cognos?
Why need staging area database for dwh?
What is the difference between a cascading report and drill through the report?
What you mean by drill across and what is the difference between drill through, drill across?
