Database Laboratory

This blog consists of technical tutorial for Structured Query Language (SQL) in MySQL and PHP.

Friday, October 20, 2017

Excluding data value in filtering

NOT operator is used to exclude certain value from the retrieved data. This operator is in syntax as below:
The example of how the operator can be used is shown in Figure 1 below:
Figure 1: Select data from student table where intake year is not 2018

at October 20, 2017
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

Search This Blog

  • Home
  • Lab 1
  • Lab 2
  • Lab 3
  • Lab 4
  • Lab 5
  • Lab 6
  • Lab 7
  • Lab 8

Report Abuse

Blog Archive

  • ►  2020 (1)
    • ►  June (1)
  • ▼  2017 (26)
    • ►  December (1)
    • ►  November (5)
    • ▼  October (14)
      • Function COUNT, SUM and AVG
      • Excluding data value in filtering
      • Retrieve, update and delete data from table with m...
      • Sorting Retrieved Data from Table
      • Retrieve Distinct Data from Table
      • Update Data in Table using SQL
      • Lab 3: Insert, Retrieve and Delete data from Datab...
      • Delete Data from Table
      • Select and Display data from Table using SQL
      • Insert Data to a table using SQL command
      • Lab 2 : Manipulating Database Table Structure usin...
      • Delete a Table
      • Alter table column
      • Create Table based on ERD
    • ►  September (6)
Simple theme. Powered by Blogger.