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
- 19948 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 do you generate sequence number in datastage?
Triggers,VIEW,Procedures
Can you explain repository tables in datastage?
What are transforms and what is the differenece between routines and transforms?
In Datastage, how you can fix the truncated data error?
Define orabulk and bcp stages?
What is quality stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Why do we use link partitioner and link collector in datastage?
Name the different types of Lookups in Datastage?
Why we use surrogate key?
Explain connectivity between datastage with datasources?
EXPLAIN SCD
Can you explain kafka connector?
What is the difference between orabulk and bcp stages?
