Interested to Buy Any Domain ? << Click Here >> for more details...
How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
- 2 Answers
- 6860 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
this is can acheieve by following query
select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / priyank
select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are Business Components in Informatica?
What is a poling?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain pushdown optimization and types in informatica
Can anyone please distinguish what is Inner join and Outer join
difference between source based commit? and target based commit? which is better with respect to performance?
How to create or import flat file definition in to the warehouse designer?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
What is the advantage of informatica?
Why you use repository connectivity?
Teradata 
