sql

Selecting a distinct values and its number of occurrence from database

  • by admin
  • 0

Selecting a distinct values and its number of occurrence from database using SQL

$query=”SELECT DISTINCT(`page_id`), COUNT(page_id) as count FROM tablename group by page_id”;

Selecting a distinct values and its number of occurrence from database using SQL $query=”SELECT DISTINCT(`page_id`), COUNT(page_id) as count FROM tablename group by page_id”;

Selecting a distinct values and its number of occurrence from database using SQL $query=”SELECT DISTINCT(`page_id`), COUNT(page_id) as count FROM tablename group by page_id”;