TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQL SELECT NULL
SQL select null keyword with sql, tutorial, examples, insert, update, delete, select, join, database, table, join
SQL SELECT NULLFirst of all we should know that what null value is? Null values are used to represent missing unknown data. There can be two conditions:
If in a table, a column is optional, it is very easy to insert data in column or update an existing record without adding a value in this column. This means that field has null value. Note: we should not compare null value with 0. They are not equivalent.Where SQL is NULL:
How to select records with null values only? (in the marks column) There is an example of student table:
Let's see the query to get all the records where marks is NULL: SELECT SIR_NAME, NAME, MARKS FROM STUDENTS WHERE MARKS IS NULL It will return the following records:
Where SQL is NOT NULL:
How to select records with no null values(in marks column)? Let's see the query to get all the records where marks is NOT NULL SELECT SIR_NAME, FIRSTNAME, MARKS FROM STUDENTS WHERE MARKS IS NOT NULL
Next TopicSQL WHERE Clause
|
Related Links:
- SQL Interview Questions (2021)
- Learn SQL Tutorial
- Top 45 SQL Server Interview Questions (2021)
- SQL SELECT RANDOM
- SQL SELECT AS
- SQL SELECT IN
- SQL SELECT from multiple tables
- SQL SELECT DATE
- SQL SELECT SUM
- SQL SELECT NULL
- SQL WHERE
- SQL AND
- SQL OR
- SQL WITH
- SQL ORDER BY ASC
- SQL ORDER BY DESC
- SQL ORDER BY RANDOM
- Learn Sql Server Tutorial
- SQL ORDER BY LIMIT
- SQL ORDER BY Multiple Columns
- SQL INSERT
- SQL INSERT Multiple Rows
- SQL UPDATE
- SQL UPDATE with JOIN
- SQL UPDATE DATE
- SQL DELETE
- SQL DELETE ROW
- SQL DELETE all rows
- SQL DELETE JOIN
- SQL DELETE duplicate rows
- SQL DELETE DATABASE
- SQL DELETE VIEW
- SQL JOIN
- SQL OUTER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL CROSS JOIN
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- SQL COMPOSITE KEY
- SQL vs NoSQL
- SQL Quiz | SQL Online Test
- SQL vs SQLite
- SQL Data Types
- SQL Operators
- SQL CREATE Database
- SQL DROP Database
- SQL Syntax
- SQL RENAME Database
- SQL SELECT Database
- SQL Table
- SQL CREATE Table
- SQL DROP Table
- SQL DELETE TABLE
- SQL RENAME Table
- SQL TRUNCATE Table
- SQL COPY Table
- SQL SELECT COUNT
- SQL SELECT TOP
- SQL ORDER BY
- SQL TEMP Table
- SQL ALTER Table
- SQL SELECT
- SQL SELECT UNIQUE
- SQL SELECT DISTINCT
- SQL SELECT FIRST
- SQL SELECT LAST