SQL Interview Questions and Answers
Thursday, April 17, 2014
Name 3 ways to get an accurate count of the number of records in a table?
SELECT * FROM table 1
SELECT COUNT(*) FROM table 1
SELECT rows FROM sysindexes WHERE id = OBJECTJD(table 1) AND indid < 2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment