Write a query to get last 10 records from the table.
- 12 Answers
- 24731 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / siddharthapenchala
select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is nosql example?
Show the two pl/sql cursor exceptions.
What is java sql drivermanager?
how to present a past time in hours, minutes and seconds? : Sql dba
Do we need to create index on primary key?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why left join is used in sql?
How to return an array from java to pl/sql?
describe mysql connection using mysql binary. : Sql dba
Which is better trigger or stored procedure?
Explain the steps needed to create the scheduled job?
Is sql an operating system?
Can delete statement be rollbacked?
What is the example of procedure?
How to revise and re-run the last sql command?
