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
- 19579 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarath
for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Define orabulk and bcp stages?
What is usage analysis in datastage?
Why do you need stage variables?
What is the method of removing duplicates, without the remove duplicate stage?
How we can covert server job to a parallel job?
What are the steps required to kill the job in Datastage?
What is difference between server jobs & parallel jobs?
Can you explain link buffering?
What are the repository tables in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Can you filter data in hashed file?
What are the types of jobs we have in datastage?
Why do we use link partitioner and link collector in datastage?
Which algorithm you used for your hashfile?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
