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
- 6943 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 |
what is degenerated dimension
what is index?how it can work in informatica
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
What is data movement mode in Informatica and difference between them?
Explain about Informatica server process that how it works relates to mapping variables?
What is a sequence generator transformation?
In session log thier should not be a single error how will u do
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
What are the main issues while working with flat files as source and as targets ?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
What is the need of etl tools?
what is $$$$?
Teradata 
