What is set function in sql .E.g.What is difference between
union and union all
Answers were Sorted based on User's Feedback
Answer / durga
set operators are used to combine the out put of more than
one query.
union: used to combine the output Query1 and query2
and display them uniquely
union all : it would combine the two query and displays then
as its duplicates.
| Is This Answer Correct ? | 10 Yes | 0 No |
set operators are used to combine the out put of more than
one query.
union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1
union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.
| Is This Answer Correct ? | 3 Yes | 0 No |
in procedure how to return a value
What is a value set? List its various types.
What are the requests groups?
what is latest version in reports
In hierarchical structure of a database? we have write query from where we should start?
How do u identity its name of report?
What are the files we submit while your program move to testing instance?
Define MultiOrg Structure
What is multoorg and what is it's level or structure
In which directory your flatfile is given?if u connected different instance where it is find?
while running a interface if we get 100 records as erors. how to debug it.
what are the prerequisite set ups for inter organization transaction?