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
What are the different options associated with dsjob command?
What is a merge in datastage?
Triggers,VIEW,Procedures
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How can we improve the performance in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
how do u catch bad rows from OCI stage? And what CLI stands for?
Is possible to create skid in dim,fact tables?
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
To see hidden files in LINIX?
what is the use of surogate key in datastage
What is merge stage?
table actions available in oracle connector?
What is a quality stage in datastage tool?
What are the features of datastage flow designer?