Syntax error (operator missing) in query-expression?

Question

I'm trying to understand COUNT(*), and therefore I created a testing query:

 SELECT COUNT(*)
 WHERE COUNT(UITLENINGEN.LLNR) >= 30;

When I click Execute, I get the following error:

Syntax error (operator missing) in query-expression COUNT(*) WHERE COUNT(UITLENINGEN.LLNR) >= 30.

What am I doing wrong?

The table name is UITLENINGEN, I put it in between the COUNT brackets. — Tanno
– Tanno, Commented Nov 27, 2012 at 8:57
SELECT COUNT(*) FROM UITLENINGEN WHERE COUNT(UITLENINGEN.LLNR) >= 30; — Codesen
– Codesen, Commented Nov 27, 2012 at 8:58

Codesen · Accepted Answer · 2012-11-30 06:35:40Z

1

Try this

SELECT COUNT(*) FROM UITLENINGEN GROUP BY LLNR HAVING COUNT(UITLENINGEN.LLNR) >= 30;

edited Nov 30, 2012 at 6:35

answered Nov 27, 2012 at 8:58

Codesen

7,8425 gold badges31 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tanno Over a year ago

I get the following error (translated from Dutch): You cannot use a statistic function in a WHERE-component (COUNT(UITLENINGEN.LLNR) >= 30). Should I perhaps try HAVING?

Codesen Over a year ago

select count(*) from UITLENINGEN having count(UITLENINGEN.LLNR) >= 30;

HansUp · Accepted Answer · 2012-11-27 18:20:57Z

1

I don't understand what you're trying to do. The query below is based on a table which includes a field named category_id. And it uses GROUP BY category_id to count the number of rows within each such group. The HAVING clause limits the result set to only those groups whose count is at least 30.

SELECT category_id, COUNT(*)
FROM YourTable
GROUP BY category_id
HAVING COUNT(*) >= 30;

If that is nothing like what you're trying to accomplish, please give us more detailed information so we may better understand your situation. A brief set of sample data, and the output you want based on that sample, would help tremendously.

answered Nov 27, 2012 at 18:20

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

Comments

Debobroto Das · Accepted Answer · 2012-11-27 08:57:53Z

0

You have not specified the table from which the data should be retrieved. Try the following

 SELECT COUNT(*) from tableName
    WHERE COUNT(UITLENINGEN.LLNR) >= 30;

answered Nov 27, 2012 at 8:57

Debobroto Das

8626 silver badges16 bronze badges

Comments

Sid · Accepted Answer · 2012-11-27 08:57:57Z

0

Add your table name to the query.

SELECT COUNT(*) FROM UITLENINGEN WHERE COUNT(UITLENINGEN.LLNR) >= 30;

answered Nov 27, 2012 at 8:57

Sid

1,2532 gold badges26 silver badges47 bronze badges

2 Comments

Tanno Over a year ago

I get the following error (translated from Dutch): You cannot use a statistic function in a WHERE-component (COUNT(UITLENINGEN.LLNR) >= 30). Should I perhaps try HAVING?

Sid Over a year ago

@Tanno what exactly do you want to do?

bluish · Accepted Answer · 2012-11-27 09:32:22Z

0

Please, add table name and use having statement where aggregation funcion required. E.g.:

select count(*) 
from UITLENINGEN
having count(UITLENINGEN.LLNR) >= 30;

edited Nov 27, 2012 at 9:32

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Nov 27, 2012 at 9:14

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

Syntax error (operator missing) in query-expression?

5 Answers 5

2 Comments

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related