Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Select / SQL Tutor, Select Where Clouse, Not Equal
28/05/2024SQL SELECT, WHERE clause, <> operator
SQL SELECT, WHERE clause, <> operator
When you define the condition in the WHERE clause, you can use the <> operator.
Where condition, <> operator, syntax
SELECT * FROM books WHERE cost <> ‘value1’;
SELECT title, author FROM books WHERE author <> ‘value1’;
SELECT title, author FROM books WHERE author <> ‘value1’;
SELECT statement with WHERE, <> operator, examples
SELECT title, author FROM books WHERE cost <> ’20.25’;
Database Blog
Firebird SQL Tutor
SQL Select
- Select, Where
- Select, Where Compare
- Select, Where Equal
- Select, Where Greater Than
- Select, Where Less Than
- Select, Where Greater Than, Equal
- Select, Where Less Than, Equal
- Select, Where Not Equal
- Select, Where Between
- Select, Where IN
- Select, Where LIKE
- Select, Where Wildcards
SQL Select AND, OR, NOT
SQL Select ORDER BY
SQL Select DISTINCT
SQL FUNCTIONS
- Functions, Count
- Functions, Sum
- Functions, Avg
SQL RESERVED WORDS
SQL UPDATE
Database Software for Windows:
Handy Managers
Organizer Advantage
Label Printer Advantage
Organizer Advantage Database:
Organizer Advantage, Simple Database Solutions
Organizer Advantage, Business Database Solutions
Copyright © 2024 · All Rights Reserved · PrimaSoft PC