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
- 19959 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / segu satish
answer for 3rd question:
select * from emp where rowid =(select max(rowid) from emp)
| Is This Answer Correct ? | 13 Yes | 1 No |
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 |
Answer / 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 |
Answer / sarath
for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ravi
1 answere : we can use @rownum =1 and reject the first record....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subbu
2nd answer:
select * from(select rowid from tablename where rowid between 5 and 7);
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ritesh chatterjee
Answer to Qust 1
Sed 1d "Dataset Name" from unix by this way you can delete
1st record from dataset,in place of 1 you can place any number.
Answer to Question 2
select * from tablename
where rowid between 2 and 7;
Answer to 3rd qus:-
select * from tablename
where rownum = 40;
| Is This Answer Correct ? | 0 Yes | 3 No |
whats difference between ls -ltr and ls -lrt?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
What is process model?
State the difference between an operational datastage and a data warehouse?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
What are the areas of application?
What is difference between symmetric multiprocessing and massive parallel processing?
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
Why we use parameters instead of hard code in datastage.
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is lookup table?
Teradata 
