Please let me know if UNION ALL and Natural Join does the
same operation and are same...
Answer Posted / brahma
both are return same result
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
Is coalesce faster than isnull?
What is the difference between sum and count in sql?
What are actual parameters and formal parameters?
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
give the syntax of grant and revoke commands? : Sql dba
What is dense_rank?
write an sql query to find names of employee start with 'a'? : Sql dba
How to start the command-line sql*plus?
What are data types in pl sql?
How do I view an execution plan in sql?
What programs use sql?
What is a database trigger?
what is the difference between char_length and length? : Sql dba
What are stuff and replace function?
What is coalesce sql?