About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
100 SQL Problem Scenario and Solutions
Course Schemas and Tables
Course Schemas and Tables
Preview
Course Requirements
Course Requirements
Oracles Installation
Oracles Installation
OracleXE 64bit
SQL Developer
SQL Developer
SQL Developer Install
Population Data for Zara's Groceries
Population Data for Zara's Groceries
Download Export Script
Select Statement
Select Statement
Table Familiarization
Table Familiarization
Where Clause
Where Clause
Statement Stage One
Statement Stage One
Max, Min and Avg Functions
Max, Min and Avg Functions
Alias
Alias
Concatenation
Concatenation
IN Operator
IN Operator
Between
Between
Sum
Sum and Subtraction
Round Function
Round Function
Not Equal <>
Not Equal <>
Floor Function
Floor Function
Order By
Order By
Length Function
Length Function
LEFT and RPAD
LEFT and RPAD
Substring
Substring
Add Month Function
Add Month Function
Months Between
Months Between
TO_CHAR Function
TO_CHAR Function
Next Day Function
Next Day Function
Nested SQL Function
Nested SQL Function
Ampersand Operator
Ampersand Operator
Group By
Group By
Having Clause
Having Clause
Case
Case
Joins
Joins
Sub Query
Sub Query
Zara's Groceries Task 1-20
Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
Task 10
Task 11
Task 12
Task 13
Task 14
Task 15
Task 16
Task 17
Task 18
Task 19
Task 20
Unlocking the HR Schema
Unlocking the HR Schema
Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
Task 10
Task 11
Task 12
Task 13
Task 14
Task 15
Task 16
Task 17
Task 18
Task 19
Task 20
Task 21
Task 22
Task 23
Task 24
Task 25
Task 26
Task 27
Task 28
Task 29
Task 30
Populating Data for Job Selection Task
Data for Job Selection Task
Task 1
Task2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
Task 10
Task 11
Task 12
Task 13
Task 14
Task 15
Task 16
Task 17
Task 18
Task 19
Task 20
Not Equal <>
100 SQL Problem Scenario and Solutions
By:
OLALEKAN DAVID-BANJO
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
We'll cover the following topics in this section:
Not Equal <>
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts