{"id":"https://openalex.org/keywords/group-by","display_name":"GROUP BY","description":"GROUP BY is a clause in SQL that groups rows sharing specified values for aggregation or grouped query results.","display_name_alternatives":["SQL GROUP BY","GROUP BY clause","SQL grouping clause"],"ids":{"openalex":"https://openalex.org/keywords/group-by","wikidata":"https://www.wikidata.org/wiki/Q13222055"},"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7607,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7607,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"works_count":184,"cited_by_count":3580,"works_api_url":"https://api.openalex.org/works?filter=keywords.id:keywords/group-by","updated_date":"2026-11-18T04:07:20","created_date":"2026-09-30T00:00:00"}
