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
discuss about myisam index statistics collection. : Sql dba
how to concatenate two character strings? : Sql dba
How do I turn a list into a table?
Is sql a case sensitive language?
Can a varchar be a primary key?
Is sql considered coding?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the use of sqldataadapter?
What is nosql db?
What are different types of tables in sql?
What is serial sql?
How to process query result in pl/sql?
How many triggers can be applied on a table?
Which type of cursor is used to execute the dml statement?
Why do we use procedures?