Interested to Buy Any Domain ? << Click Here >> for more details...
1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?
- 7 Answers
- 19594 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / srinu
1) using external filter we use command is sed we get
2)select * from (select rownum rno,emp.* from emp)
where rno in(5,6,7)
or
select * from (select rownum rno,emp.* from emp)
where rno between 5 and 7
or
select * from emp where rownum<8
minus
select * from emp where rownum<5
in first two are very efiiciency compare to third one
because in third iam using set operator
3)select * from emp where rowid=(select max(rowid) from emp);
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to read the length of word in unix?
Differentiate between validated and Compiled in the Datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the command line function to import and export the ds jobs?
What is the different type of jobs in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What steps should be taken to improve Datastage jobs?
Can you implement SCD2 using join, transformer and funnel stage?
Nls stands for what in datastage?
Explain ibm infosphere information server and highlight its main features?
why do u need the IOS upgradation in a FC switch
Why do we use link partitioner and link collector in datastage?
What is aggtorec restructure operator?
Give an idea of system variables.
Can you explain players in datastage?
