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 is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How many types of sorting methods are available in datastage?
how to add a new records into source?
Why do we use exception activity in Datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the some differences between 7.x and 8.x version of datastage?
What are the repository tables in datastage?
What is the difference between account and directory options ?
Can you define merge?
Difference between data warehousing and olap?
Explain ibm infosphere information server and highlight its main features?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the different common services in datastage?