Thanksgiving SQL Teaser COUNT

[SQLDenis]

Here is a small simple Thanksgiving teaser. What do you think will the result be of the select count query?

USE tempdb 
GO 

CREATE TABLE Customer (CustomerID INT PRIMARY KEY) 
INSERT Customer VALUES (1) 
INSERT Customer VALUES (2) 
INSERT Customer VALUES (3) 
INSERT Customer VALUES (4)

What will this return?

SELECT COUNT(*) Customer

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

 

[r937]

my guess:

Spoiler

1

denis, this was the first one of your teasers in a long time that i was able to guess correctly

they are usually a lot harder



r937.com | rudy.ca

 

[SQLDenis]

You are saying I am losing my 'touch'

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

 

[kaht]

Denis, don't suppose that was inspired by the recent blogspot post?

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson
[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B> bites again.[/small]

 

[SQLDenis]

yes it was

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

 

[fredericofonseca]

Yeah. Easy one. not fun.

Spoiler

1

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[AlexCuse]

You are saying I am losing my 'touch'

That would imply you had it to begin with ;-)

Hopefully we get some nice new teasers soon since there will be some new stuff to play with in SQL 2008 :-D



[small]----signature below----[/small]
You can't fit a square data in a round table