How do you find the number of rows in a table?
Answers were Sorted based on User's Feedback
Answer / uma lakshman
Hokar, You are right. But using count(*) is not optimal.
I wud suggest going for sysindexes table to find the number
of rows in a particular table.
SELECT rows FROM sysindexes WHERE id = OBJECT_ID
('table_name')
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kumar.t
Select Rows From SysIndexes Where Id = Object_Id
('tablename') And IndId<2
Uma Lakshman answer is wrong.
It Is Correct Answer
By
Kumar.T
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / raghuram
the question is how do find number of rows in a table?
select count(*) from table_name
by using this we will get exact number of rows in a table.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / anand
select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manoj savalia
Try This
SELECT SYS_OBJ.NAME AS "TABLE NAME"
, SYS_INDX.ROWCNT AS "ROW COUNT"
FROM SYSOBJECTS SYS_OBJ, SYSINDEXES SYS_INDX
WHERE SYS_INDX.ID = SYS_OBJ.ID
AND INDID IN(0,1)
AND XTYPE = 'U'
AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'
AND SYS_INDX.ROWCNT>0
ORDER BY SYS_INDX.rowcnt DESC
Is This Answer Correct ? | 0 Yes | 0 No |
select @@rowcount
select count(*) from tablename
Is This Answer Correct ? | 5 Yes | 7 No |
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Define outer join?
How to select nth record from a table?
13 Answers DELL, Microsoft, Ramco,
How many triggers you can have on a table?
Can group by be used without aggregate functions?
Explain linked server in sql?
Alternative way to DetDate() function?
What is compression - row-level and page-level compression?
How to count duplicated values in a column in ms sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
Explain the architecture of SQL Server?
Can we write a distributed query and get some data which is located on other server and oracle database?