table

Question

Post reply

table

Subu

Say Hey Kid

Points: 680
More actions
September 15, 2007 at 10:51 pm

#181083

How can i count no of row in a table plz tel me query

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110208 More actions · Answer 1

Just use system function COUNT.

_____________
Code for TallyGenerator

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

Sounds like you need an intro to SQL... here's a good overview...

http://www.sql-tutorial.net/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

murali krishna-491058 Grasshopper Points: 23 More actions · Answer 3

select count(columnname) from tablename

this will let u know how many rows u hav..any column name would do good

David McFarland SSChampion Points: 11815 More actions · Answer 4

Actually, that might be a bad idea. Count(columnname) only returns the count of rows where that column is not null. Count(*) returns the actual count, including rows with nulls. I'd also second Jeff Moden's recommendation and add that you might take a gander at BOL as a starting point for these types of things.