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
- 20154 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarath
for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How do you remove duplicate values in datastage?
What is the differentiate between data file and descriptor file?
how to write server Routine coding?
What are the different kinds of views available in a datastage director?
Describe link sort?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Whats difference betweeen operational data stage (ods) and data warehouse?
root tree will find which is server job and which is parallel job?
Does datastage support slowly changing dimensions ?
How and where you used hash file?
What are data elements?
why do u need the IOS upgradation in a FC switch
table actions available in oracle connector?
What is difference between symmetric multiprocessing and massive parallel processing?
How can we improve performance of data stage jobs?
