Do you know TABLESAMPLE in SQL Server 2005?
Assume that your tblEmployee in SQL Server 2005 table contains more than 10 records.
Which querie(s) below return exact 10 records?
1. SELECT EmployeeID, EmployeeName
FROM tblEmployee TABLESAMPLE (10 ROWS)
2. SELECT TOP 10 EmployeeID, EmployeeName
FROM tblEmployee
A. Query 1
B. Query 2
C. Both queries
D. No query return exact 10 records
Answer:[B]
Highlight to find out the answer.
Tuesday, March 23, 2010
TABLESAMPLE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment