Chapter 11 Notes
Unit 3 Database Management · Chapter 11
Retrieve Data Using Query & SQL
Master database extraction in LibreOffice Base: Query Design View Grid, Writing Structured Query Language (SQL) statements, Wildcard Pattern Matching, Sorting with ORDER BY, and Aggregations with GROUP BY.
Chapter 11 Theory
1. Query Design View Grid Elements
FieldColumn
AliasCustom Header
TableSource
SortAsc / Desc
VisibleOutput Check
CriterionCondition
2. Essential SQL Query Syntax
-- Filter students with marks >= 80, sorted highest to lowest
SELECT RollNo, StudentName, Marks FROM Students WHERE Marks >= 80 ORDER BY Marks DESC;
SELECT RollNo, StudentName, Marks FROM Students WHERE Marks >= 80 ORDER BY Marks DESC;
-- Wildcard pattern matching: Names starting with 'R'
SELECT * FROM Employees WHERE EmpName LIKE 'R%';
SELECT * FROM Employees WHERE EmpName LIKE 'R%';
Chapter 11 Practice
Solved MCQs: Query & SQL Commands
1
In SQL queries, which wildcard character in LibreOffice Base represents zero, one, or multiple characters with the LIKE operator?
2
Which SQL clause is used to filter records that meet a specified condition?
3
Which row in the Query Design View grid determines whether a field appears in the output datasheet result?
4
Which SQL keyword sorts output records in ascending or descending sequence?
Frequently Asked Board Questions