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?
Answer Posted / subbu
2nd answer:
select * from(select rowid from tablename where rowid between 5 and 7);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the various kinds of the hash file?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
To see hidden files in LINIX?
What are transforms and what is the differenece between routines and transforms?
what is the use of surogate key in datastage
What is "fatal error/rdbms code 3996" error?
How many Key we can define in remove duplicate stage?
What is a folder? Difference types of stages?
What are the job parameters?
Define orabulk and bcp stages?
What is difference between join, merge and lookup stage?
Define Merge?
What is the difference between passive stage and active stage?
How do you run datastage job from the command line?