What is the difference between UNION and UNIONALL?
- 5 Answers
- 12117 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
union is used to retreive the data with out duplication
union all is used to retreive the data with duplication
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How to query multiple tables jointly?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How many database files are there in sql server 2000?what are they?
Do you know data definition language, data control language and data manipulation language?
Tell me what is the significance of null value and why should we avoid permitting null values?
How connect excel to sql server?
What do you understand by recursive stored procedures?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is msdb database? : SQL Server Architecture
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
what is a join? : Sql server database administration
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How does a profiler work?
What is a not null constraint?
What is table value parameters (tvp)?
