Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8326 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 tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What do you understand by the term 'aggregate cache'?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
How can create users and permissions in cognos?
Can you define bitmap index?
What is the difference between a cascading report and drill through report?
What are the types of catalogs in cognos?
How to publish a package by running Java Script?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
what is catalog and types of catalogs in cagnos and which is better?
What is difference between page break and section report?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
what is the difference between querystudio in reportnet and cognos8
What is the use of Cognos scenario?
