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 / 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
How to read the length of word in unix?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Can you highlight the main features of ibm infosphere information server?
How do you schedule or monitoring the job?
Is it possible to query a hash file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How you Implemented SCD Type 1 & Type 2 in your project?
What is data partitioning?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How will you move hashed file from one location to another location?
Differentiate between operational datastage (ods) and data warehouse?
What are the job parameters?
Can you explain repository tables in datastage?
EXPLAIN SCD
How to clean the datastage repository?