DB8 SQL Queries 2024 with complete solution

DB8 SQL Queries 2024 with complete solution

,DB8 SQL Queries 2024 with complete solution




Database
Management
More on SQL Queries

,SQL Queries: Review

 SQL query has a form
SELECT . . .
FROM . . .
WHERE . . . ;
 The SELECT clause says which Attribute(s) we are
interested in
 The FROM clause says which Relation(s) we refer to
 The WHERE clause says which Tuple(s) we refer to

, Case Insensitivity

 SQL is case insensitive
 So, keyword FROM maybe written as:
 FROM or
 From or
 FrOm
 Only in strings, SQL distinguishes between an the
uppercase lowercase d
 So, the following are different strings:
• ’FROM’
• ’From’
• ’FrOm’