Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 20145 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / reddy obul
__for 2nd question answer is:
select * from table where rowid<8 minus select * from table
where rowid<5
__for 3rd quesion answer is:
select * from emp where rowid in(select max(rowid) from emp)
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
What is meta stage?
What is the precedence of stage variables,derivations, and constraints?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Why do we use exception activity in Datastage?
What are transforms and what is the differenece between routines and transforms?
What are the functionalities of link collector?
What are the types of views in datastage director?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Have you used Unstructured data?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the primary usages of datastage tool?
Difference between in process and inter process?
How to reverse the string using SQL?
