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
- 19920 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 use Array size in datastage
Explain entity, attribute and relationship in datastage?
What are system variables and sequencers in datastage
How do you reject records in a transformer?
Different ways a project can be moved to production ?...example ….export-import and Version control.
I have a few records just I want to store data in to targets cycling way how?
What are the features of datastage flow designer?
What is the difference between account and directory options ?
Differentiate between operational datastage (ods) and data warehouse?
EXPLAIN SCD
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the project in datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the components of datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
