SQL Teaser: uniqueidentifier

[SQLDenis]

create table #Foobahar (id int,Col uniqueidentifier)
insert #Foobahar values(1,'FD788D60-E5F8-4969-9733-F88186B7EE63')
insert #Foobahar values(2,'78E89339-F5A0-46B9-961E-AC4681B63075')
insert #Foobahar values(3,'BE9E0439-5626-42B5-955B-1FD831BF7CAF')

without running this, which GUID do you think will be returned

select min(Col) from #Foobahar

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[chrissie1]

Either

Spoiler

FD788D60-E5F8-4969-9733-F88186B7EE63

Or

Spoiler

78E89339-F5A0-46B9-961E-AC4681B63075

Or

Spoiler

BE9E0439-5626-42B5-955B-1FD831BF7CAF

Christiaan Baes
Belgium

"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett

 

[gmmastros]

Chrissie,

Would you be surprised to know that all of your choices are wrong?

-George

"the screen with the little boxes in the window." - Moron

 

[chrissie1]

No

Christiaan Baes
Belgium

"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett

 

[AlexCuse]

Spoiler

I'd guess that you get some red text in the messages tab...

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[Lamprey13]

Spoiler

None. You cannot use an aggregate function on a uniqueidentifier. Nor can you use one on bit fields. And probably some other types I cannot think of right now.

 

[ESquared]

And these...

SELECT Convert(uniqueidentifier, Min(Convert(binary(16), Col))) from #Foobahar

SELECT Convert(binary(16), col) from #Foobahar

[COLOR=black #d0d0d0]My alarm clock causes time travel. When I hit snooze, no apparent time passes before the alarm sounds again, but the universe has in fact moved forward through time by ten minutes![/color]

 

[SQLDenis]

or just this one

select min(convert(varchar(36),col))
from #Foobahar

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions