Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26266 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / swastik
SELECT ROWNUM, E1.*
FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)E1
WHERE ROWNUM <= 10
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is sap sql anywhere?
What are the different types of sql commands?
What is duration in sql profiler trace?
What are the disadvantages of not performing database normalization?
Can we use pl sql in mysql?
Which is the correct statement about truncate and delete?
What are different types of keys?
Is left join and outer join same?
What is rank function in sql?
What are the main features of cursor?
how to present a past time in hours, minutes and seconds? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Explain scalar functions in sql?
Why indexing is needed?
