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
- 19578 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / srinu
1) using external filter we use command is sed we get
2)select * from (select rownum rno,emp.* from emp)
where rno in(5,6,7)
or
select * from (select rownum rno,emp.* from emp)
where rno between 5 and 7
or
select * from emp where rownum<8
minus
select * from emp where rownum<5
in first two are very efiiciency compare to third one
because in third iam using set operator
3)select * from emp where rowid=(select max(rowid) from emp);
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How you Implemented SCD Type 1 & Type 2 in your project?
What are some prerequisites for datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is a merge?
Define repository tables in datastage?
What is aggtorec restructure operator?
What is data partitioning?
Describe the architecture of datastage?
What is the use of datastage designer?
What is the difference between operational data stage (ods) and data warehouse?
How many types of views are there in a datastage director?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are system variables and sequencers in datastage
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.
EXPLAIN SCD
