Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How do you find the number of rows in a table?

Answers were Sorted based on User's Feedback



How do you find the number of rows in a table?..

Answer / hokar

select count(*) from tablename.

Is This Answer Correct ?    27 Yes 2 No

How do you find the number of rows in a table?..

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

How do you find the number of rows in a table?..

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

How do you find the number of rows in a table?..

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

How do you find the number of rows in a table?..

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

How do you find the number of rows in a table?..

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

How do you find the number of rows in a table?..

Answer / elumalai.k

select @@rowcount
select count(*) from tablename

Is This Answer Correct ?    5 Yes 7 No

Post New Answer

More SQL Server Interview Questions

How to use values from other tables in update statements in ms sql server?

0 Answers  


In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,


Explain try...catch with sql server?

0 Answers  


What languages bi uses to achieve the goal?

0 Answers  


What action plan is preferred if sql server is not responding?

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


What are the types of database recovery models?

0 Answers   HCL,


What are the properties and different types of sub-queries?

0 Answers  


How to delete a login name in ms sql server?

0 Answers  


Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,


write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,


Define a cross join?

0 Answers  


Categories