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 / segu satish
answer for 3rd question:
select * from emp where rowid =(select max(rowid) from emp)
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
project Steps,hits, Project level HArd things,Solved methods?
What are the processing stages?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How we can covert server job to a parallel job?
root tree will find which is server job and which is parallel job?
What is the difference between hashfile and sequential file?
What are the types of hashed files in data stage
why do u need the IOS upgradation in a FC switch
how to delete one row in target dataset
What is the importance of the exception activity in datastage?
What are constraints and derivations?
On which Dimension Table you implemented SCD Type in your Project
whom do you report?
How can we improve the performance in datastage?
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