Sql

SELECT 
    fruit_name,
    color,
    COUNT(*)
FROM 
    fruits
GROUP BY 
    fruit_name,
    color
HAVING COUNT(*) > 1;

PREVIOUS	NEXT

Code Example
Sql :: sql select into statement
Sql :: create or replace view postgress
Sql :: oracle first row
Sql :: sql update where id
Sql :: select where duplicate mysql
Sql :: extract weekday from date in sql
Sql :: postgres list databases
Sql :: create temporal table in sql
Sql :: mysql between
Sql :: import all databases mysql
Sql :: mysql isnull
Sql :: t-sql drop function if exists
Sql :: oracle running queries sql
Sql :: SQL Server lock table example
Sql :: sql all columns
Sql :: postgresql append array
Sql :: What is dialect for Postgres
Sql :: incompatible sql_mode=only_full_group_by
Sql :: multiple like in sql
Sql :: empty table sqlite
Sql :: return result of function in postgresql
Sql :: mysql group by date
Sql :: sql server insert inner join
Sql :: json with root element in sql server
Sql :: insert into using contant values and source table columns with sql
Sql :: mysql query with sql to get the next row
Sql :: get clob size oracle
Sql :: get max salary from each department sql
Sql :: sqlite3 turn off case sensitive
Sql :: SQL Add Column in a Table