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 / ravi
1 answere : we can use @rownum =1 and reject the first record....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How you can fix the truncated data error in datastage?
What is aggtorec restructure operator?
What are system variables and sequencers in datastage
Explain entity, attribute and relationship in datastage?
In Datastage, how you can fix the truncated data error?
Explain usage analysis in datastage?
What is staging variable?
Describe stream connector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain connectivity between datastage with datasources?
How to perform incremental load in datastage?
What is the difference between server job and parallel jobs?
What is a datastage job?
whom do you report?