{"id":"https://openalex.org/keywords/where-clause","display_name":"WHERE clause","description":"A clause in SQL queries that filters rows according to specified conditions when retrieving or manipulating data in a database.","display_name_alternatives":["SQL WHERE clause","WHERE clauses"],"ids":{"openalex":"https://openalex.org/keywords/where-clause","wikidata":null},"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5191,"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.5191,"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"}},{"id":"https://openalex.org/T10034","display_name":"Syntax, Semantics, Linguistic Variation","score":0.1094,"subfield":{"id":"https://openalex.org/subfields/1203","display_name":"Language and Linguistics"},"field":{"id":"https://openalex.org/fields/12","display_name":"Arts and Humanities"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"works_count":122,"cited_by_count":495,"works_api_url":"https://api.openalex.org/works?filter=keywords.id:keywords/where-clause","updated_date":"2026-11-17T04:05:58","created_date":"2026-09-30T00:00:00"}
