Returning less number of rows

[shivan]

the second statement doesnt run in sql server. I m trying to run the query i get the error:
Line 1: Incorrect syntax near ')'
thanks
shivan

Try these queries against the database.

Code: Select all

SELECT COUNT(*) FROM tablename;
SELECT COUNT(*) FROM (SELECT A,COUNT(*) FROM tablename GROUP BY A);

What do these tell you about grouping?

[Sainath.Srinivasan]

Give an alias from the sub-table.

[shivan]

i still have the same problem. The query i wrote is this:
SELECT COUNT(*) FROM (SELECT a.lf_id,COUNT(*) FROM escalation a GROUP BY a.lf_id)

thanks
shivan

Give an alias from the sub-table.