Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anil
select * from emp where rownum <=5 minus
select * from emp where rownum <5
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is materialized view in sql?
How to disable a trigger name update_salary?
What is the difference between joins?
What are two statement types in sql?
What is sqlerrm?
What are % type and % rowtype?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is count * in sql?
What is a pdo connection?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the purpose of design view?
what does it mean to have quoted_identifier on? : Sql dba
Can we join 3 tables in sql?
What are the possible values for the boolean data field?
What do you know by pl/sql cursors?
