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
- 20156 Views
- Wipro, I also Faced
- E-Mail Answers
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
options available in sequence job to run,validate?
State the difference between an operational datastage and a data warehouse?
Is possible to create skid in dim,fact tables?
how to sort two columns in single job in datastage.
how do u catch bad rows from OCI stage? And what CLI stands for?
Explain entity, attribute and relationship in datastage?
What is the difference between in process and inter process?
What are the some differences between 7.x and 8.x version of datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do you import and export the datastage jobs?
What are the main features of datastage?
how to implement scd2 in datastage 7.5 with lookup stage
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the project in datastage?
Where do you see different stages in the designer?
