Interested to Buy Any Domain ? << Click Here >> for more details...
how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 6122 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
delete from
(select * from tab1
minus
select * from tab1 where rownum<n-2 order by rowid)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are types of exception?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What does 0 mean in sql?
when is the use of update_statistics command? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is difference between table and view?
What is the sql*loader? : aql loader
What are sql functions? Describe the different types of sql functions?
How many types of cursors are available in pl/sql?
What is normalization sql?
Explain the rollback statement?
what is offset-fetch filter in tsql? : Transact sql
What is audit logout in sql profiler?
how to create a new view in mysql? : Sql dba
what are sequences
