Select og Count i en og samme SQL ?

http://www.w3schools.com/sql/sql_count.asp

du laver bare en ekstra select:

count (*) as antal from dintabel

Svar

SELECT Feltet (SELECT COUNT(*) FROM Tabel WHERE Feltet = \'test\') AS myCount FROM Tabel WHERE Feltet = \'test\'

Men det var vel bedre at lave to stk, ellers ska Count(*) regnes ud MANGE gange

SELECT Feltet FROM Tabel WHERE Feltet = \'test\'

og

SELECT COUNT(*) AS myCount FROM Tabel WHERE Feltet = \'test\'

Altså åbne to recordsets!

Tak Idanielsen...

Selv tak