Union and Union All

Question

Viewing 8 posts - 31 through 37 (of 37 total)

You must be logged in to reply to this topic. Login to reply

Vobr Jiri SSCommitted Points: 1734 More actions · Answer 1

SSCommitted

Points: 1734

July 11, 2012 at 8:21 am

Hi experts,

Vobr Jiri SSCommitted Points: 1734 More actions · Answer 2

In this case have parentheses no role. Of principle is DISTINCT behavior of UNION clause.

TomThomson SSC Guru Points: 104773 More actions · Answer 3

SQLRNNR (7/8/2012)
bitbucket-25253 (7/7/2012)
Nice to be reminded of the basics
+1

+1 more

Tom

Neha05 Default port Points: 1494 More actions · Answer 4

Default port

Points: 1494

August 8, 2012 at 12:02 pm

Nice question!

kapil_kk SSC-Insane Points: 21316 More actions · Answer 5

It will be

A

A,A :-):-P

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

kapil_kk SSC-Insane Points: 21316 More actions · Answer 6

Nice question...

Easy one 😛

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

kalyani.k478 Default port Points: 1400 More actions · Answer 7

Default port

Points: 1400

October 22, 2012 at 11:17 pm

+1

Neeraj Prasad Sharma Ten Centuries Points: 1315 More actions · Answer 8

Thanx for the question 🙂

Neeraj Prasad Sharma
Sql Server Tutorials