Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8317 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 |
architecture of cognos8
What are the batches and it’s details?
How to deploy from one server to another server?
Can you define snapshot?
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...
how to find the rank in report studio? i need steps for this question.
Write some methods to apply securities in framework manager model?
Column level security in report
What are slice and dice?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
what is the use of lock and unlock
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
Teradata 
