Need help in a java program or rather SQL or maybe the problem is in netbeans. Actually I don't know what is the actual problem

Question

I have made a java project using netbeans and derby, with the database in netbeans itself. I don't know why but The SQL count function is not working as expected.
In the program: e.g: "SELECT COUNT(*) FROM TABLE_NAME" works and gives the result in the resultset correctly while "SELECT COUNT(AGE) FROM TABLE_NAME WHERE AGE='youth' AND CONDITION='yes' " doesn't work and there is no data in resultset available. Why????

In the Netbeans' Services: I also tried running the sql query directly on the database from the services on netbeans but here even "SELECT COUNT(*) FROM TABLE_NAME" doesn't return anything (so how am I getting the result for this in my program?!!). But "SELECT * FROM TABLE_NAME" works. The count is not working at all. Why??

Kindly help me and thank you for going through such a long question.

Reached ETC(End of thinking Capacity)

Answer 1

@cahya, yes I've tried that too but still not working.

Answer 2

@Vimal, presently I am not that active on SoloLearn + coming back after a couple of month, I realised that I need to revise the concepts and also my exams are going on now so that's why.

Answer 3

@saumya okay dear I can understand 😉

Answer 4

why you disabled the challenge button 😗😗?

Answer 5

since you don't provide the script that related to your question, it's difficult to catch the problem. It's a lot of possibilities.

cmiiw :)

Answer 6

IMHO, was you tried to using 'field alias' for your COUNT(*) ? eg:

SELECT COUNT(*) AS num_age
FROM table_name
WHERE age='youth' AND condition='yes'

so you can refer to `num_age` to get number of record that match with your criteria (rather than refer to COUNT(*) that have no 'field' name)

cmiiw :)