WHERE Clause With Single Condition
Query:
SELECT * FROM employees WHERE salary > 30000;
This query will retrieve all the rows in the employees table where salary is greater than 30000.
Output:
WHERE Clause in MariaDB
MariaDB uses SQL (Structured Query Language) and it is an open-source relational database management system (RDBMS) for managing and manipulating data. The WHERE clause in SQL queries is used to filter and obtain specific data. The ability to remove and retrieve specific data using the WHERE clause in SQL queries is one of the main features that makes MariaDB robust. This article will examine the syntax and many uses for the WHERE clause in MariaDB.
Contact Us