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
options available in sequence job to run,validate?
How do y read Sequential file from job control?
why do u need the IOS upgradation in a FC switch
What are sequencers?
Name the different sorting methods in datastage.
What is the flow of loading data into fact & dimensional tables?
What are the some differences between 7.x and 8.x version of datastage?
How to implement complex jobs in data stage?
What can we do with datastage director?
What are data elements?
how many rows sorted in sort stage by default in server jobs
Can you implement SCD2 using join, transformer and funnel stage?
Could anyone give brief explanation bout datastage admin
Whats difference betweeen operational data stage (ods) and data warehouse?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?