Write a query to get last 10 records from the table.
Answer Posted / pallavi v
with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is blob? : Sql dba
What is replication id?
Can a trigger call a stored procedure?
What is the starting oracle error number?
Explain ddl statements in pl/sql?
What is sql select statement?
What are the different dcl commands in sql?
Can we create index on primary key?
What is trigger in pl sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is sql lookup?
When sql appeared?
What is delete command in sql?
What is sqlcommand?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?