Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8278 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / srinu
select * from(select rownum r,emp.* from emp) where r=3;
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / kumar
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 1 Yes | 1 No |
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 |
can you tell me what are the dimension tables are used in project
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
what is requery in cognos?
what is filter?give me one example that you created a report in your project?
what is the security module used in cognos?
How is cognos model organization works?
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
why we r using report studio in webbased only and fm windows based only
difference between join and union in reportstudio?
is there any difference between operational database and data base?if yes what r they?
How can we find out cardinality between two tables?
Teradata 
