Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

37.7k Different Types of SQL Keys

13.6k SQL : How to update top N rec

5.68k Encryption/Decryption function

4.59k SQL : How to check if a stored

3.31k How to display SQL row data as

3.14k SQL Injection Attacks

prev 1 2 3 … 43 next

SQL Tutorial -> Sql != Operator

over 9 years ago

0
0
Positive Vote
0
Negative Vote
0
Save Favourite
0
0
0
0
366

Comment on it

<-- Chapter 8: SQL = Operator

Chapter 9

SQL != Operator

Lets see an example from the below table "employees" :-

employee_id	name	code	designation	salary
101	ABC	E-101	Engineer	12000
102	DEF	E-102	Doctor	8000
103	GHI	E-103	Software Developer	8000
104	JKL	E-104	CEO	12000
105	MNO	E-105	Software Developer	100000

!= operator example :-

copytext

SELECT * 
FROM `employees`
WHERE `name` != 'ABC';

SELECT * 
FROM `employees`
WHERE `name` != 'ABC';

Now Run this Query, we will see the output below :-

employee_id	name	code	designation	salary
102	DEF	E-102	Doctor	8000
103	GHI	E-103	Software Developer	8000
104	JKL	E-104	CEO	12000
105	MNO	E-105	Software Developer	100000

We can see here, that only those Records are displayed whose name column value is not equal to 'ABC'

Chapter 10: SQL LIKE Operator -->

Tags

mysql Sql != Operator Sql Is Not Equal to Operator

Comment on it

0 Comment(s)

Sign In

Create an account !!

OR

Register

Sign up using

OR

^* Email

^* Please enter email address ^* Please enter a valid email ^* E-mail already exists ^* Sorry, this domain is blacklisted

^* User Name

^* Email

^* Email confirmation

^* Password

^* Password confirmation

Forgot Password

Reset Password

Fill out the form below and reset your password:

Hire
Post Projects
Browse Nerds
Work
Find Projects Find Projects
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Manage
Company Company
Learn
Nerd Digest Nerd Digest
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Tech Q & A Tech Q & A
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Ask Tech Query
Post Blogs