count function gives the number of rows in a group/table. "select count(*) from employee" gives the total number of rows (employees) in the employee table.
"select count(*), department from employee group by department" gives the number of employees in each department.
"Think Mad", In case you didn't see my note in your other thread, note that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks, Jeanne Forum Bartender
Post by:autobot
There were millions of the little blood suckers. But thanks to this tiny ad, I wasn't bitten once.
a bit of art, as a gift, that will fit in a stocking