SQL Filtering records Code Example

Last Updated On Saturday 17th Jul 2021
  • SQL is written in statements that ask the database to perform many things.

  • SQL talks to the database.

	SELECT name, author FROM books WHERE ratings > 10;
	
= equal less or equal
> greater than not equal
less than != not equal
>= greater or equal BETWEEN between two values
IN in a list NOT IN not in a list
	SELECT name, author FROM books WHERE ratings BETWEEN 5 AND 10;