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
- 19592 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / subbu
2nd answer:
select * from(select rowid from tablename where rowid between 5 and 7);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are routines in datastage? Enlist various types of routines.
Have you have ever worked in unix environment and why it is useful in datastage?
How to reverse the string using unix?
How to read the length of word in unix?
What a datastage macro?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain usage analysis in datastage?
client know skid info?
I have a few records just I want to store data in to targets cycling way how?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
what is the use of skid in reporting?
describe the Steps to confiure a Qlogic switch
What is active and passive stage?
What is merge stage?
