getting the total number of records

[habneh]

I have a table say

tbl1
col1 col2
1 aa
2 bb
3 cc
4 dd

I would like to select all records and the total number of records in single statemet here is what the recordset I want

noRecords col1 col2
4 1 aa
4 2 bb
4 3 cc
4 4 dd

how can i do that

thanks

 

[AlexCuse]

like this?

select
(select count(*) from tbl1) as cnt
, col1
, col2
from tbl1

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[Zografski]

SELECT (SELECT COUNT(*) FROM YourTable) AS Snt, * from YourTable

 

[habneh]

Thanks, Alex

 

[AlexCuse]

Glad it worked

Ignorance of certain subjects is a great part of wisdom