Archive for the ‘Sql’ Category

SQL: Select Count with Group By

Saturday, November 14th, 2009
SELECT department, COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 25000
GROUP BY department

Source

Tech: Derby vs Oracle Berkely DB JE

Friday, January 16th, 2009

Great Discussion on Derby vs Oracle BDB JE

Sql: Select rows with duplicate values (select, count, group by, having)

Saturday, November 8th, 2008
select count(lastName), lastName from employee group by lastName having count(lastName) > 1;