DISREGARD THIS RANTING
Correct answer: select top 1000 col1 from bigtable, select top 10 percent col1 from bigtable
I too selected a single answer not multiple answers
KevRiley - please accept my sincere apologies for my stupidity
KevRiley the question as copied and pasted is:
You have a default standard SQL 2005 SP2 server. There is a table BigTable (col1 varchar(50)) with 10,000 rows. Which of the following statements is guaranteed to return 1000 rows
Emphasis on quaranteed added by myself.
quaranteed to me means 1,000 NOT maybe more or less ... but EXACTLY 1,000. is why I am
whle you are now saying
The quotes you provide, are exactly what I am saying with the question - TABLESAMPLE will return approximately the specified number of rows - not a guaranteed number.
Seems like the question has been re-worded but enough of this quibbling ...