Search Database SQL / Scripts

  Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

Database SQL / Scripts for '#Count' - 3 Query/Script(s) found

 Sample 1. Count Number of Departments having employee count greater than 10 ( Counting grouped by records )

SELECT  count(*) FROM EMPLOYEE group by DEPARTMENT having count(*) > 10

   Like      Feedback     Count group by records   group by   groupby

 Sample 2. Get count of Employees having salary greater than 1000

Select count(*) from EMPLOYEE e where e.salary > 1000 

   Like      Feedback     count   count of employees having salary greater than   select   query   sql

 Sample 3. Count number of records / rows in a table

select count(*) from TABLE_NAME

   Like      Feedback     count number of rows  count rows  count(*)  SQL

Subscribe to Java News and Posts. Get latest updates and posts on Java from
Enter your email address:
Delivered by FeedBurner