Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8476 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 we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
What are the components of report net?
What is difference between data mart and data warehouse?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
why we r using report studio in webbased only and fm windows based only
What are the different types of reports present in cognos?
what is the difference between aggregation and roll up aggregation?
How to a create header dynamically in a crosstab report in cognos 8.1?
can reportnet supports cubes???
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
How do we create Links & Segments in Cognos Framework Manager?
What do you mean by query studio?
Teradata 
