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?
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 |
Can you explain engine tier in information server?
How many nodes supported by a one cpu in parallel jobs?
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
Can you explain link buffering?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
Explain briefly scd type2 in datastage7.5x2(parallel)
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how CAN we remove duplicates in dataset?
How we can covert server job to a parallel job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the partition techniques available in your last project?
detail about sdlc