About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

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

Nested SQL Function

100 SQL Problem Scenario and Solutions Nested SQL Function
By: OLALEKAN DAVID-BANJO
2 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$9.99
List Price:  $13.99
You save:  $4
€8.50
List Price:  €11.91
You save:  €3.40
£7.41
List Price:  £10.38
You save:  £2.96
CA$13.76
List Price:  CA$19.27
You save:  CA$5.51
A$15.14
List Price:  A$21.21
You save:  A$6.06
S$12.81
List Price:  S$17.94
You save:  S$5.13
HK$77.68
List Price:  HK$108.78
You save:  HK$31.10
CHF 7.94
List Price:  CHF 11.12
You save:  CHF 3.18
NOK kr99.30
List Price:  NOK kr139.06
You save:  NOK kr39.76
DKK kr63.48
List Price:  DKK kr88.90
You save:  DKK kr25.41
NZ$17.05
List Price:  NZ$23.88
You save:  NZ$6.82
د.إ36.68
List Price:  د.إ51.37
You save:  د.إ14.69
৳1,216.17
List Price:  ৳1,703.13
You save:  ৳486.95
₹880.11
List Price:  ₹1,232.50
You save:  ₹352.39
RM42.02
List Price:  RM58.85
You save:  RM16.82
₦14,931.85
List Price:  ₦20,910.57
You save:  ₦5,978.72
₨2,835.89
List Price:  ₨3,971.38
You save:  ₨1,135.49
฿318.04
List Price:  ฿445.38
You save:  ฿127.34
₺413.37
List Price:  ₺578.89
You save:  ₺165.51
B$53.18
List Price:  B$74.48
You save:  B$21.29
R173.25
List Price:  R242.61
You save:  R69.36
Лв16.62
List Price:  Лв23.28
You save:  Лв6.65
₩13,958.32
List Price:  ₩19,547.24
You save:  ₩5,588.92
₪33.32
List Price:  ₪46.67
You save:  ₪13.34
₱568.89
List Price:  ₱796.68
You save:  ₱227.78
¥1,477.88
List Price:  ¥2,069.62
You save:  ¥591.74
MX$183.86
List Price:  MX$257.48
You save:  MX$73.61
QR36.33
List Price:  QR50.88
You save:  QR14.54
P133.12
List Price:  P186.42
You save:  P53.30
KSh1,290.60
List Price:  KSh1,807.36
You save:  KSh516.76
E£481.18
List Price:  E£673.85
You save:  E£192.66
ብር1,434.31
List Price:  ብር2,008.61
You save:  ብር574.30
Kz9,110.43
List Price:  Kz12,758.25
You save:  Kz3,647.82
CLP$9,540.84
List Price:  CLP$13,361
You save:  CLP$3,820.16
CN¥71.08
List Price:  CN¥99.54
You save:  CN¥28.46
RD$619.60
List Price:  RD$867.69
You save:  RD$248.08
DA1,294.51
List Price:  DA1,812.83
You save:  DA518.32
FJ$22.49
List Price:  FJ$31.50
You save:  FJ$9
Q76.54
List Price:  Q107.20
You save:  Q30.65
GY$2,090.76
List Price:  GY$2,927.91
You save:  GY$837.14
ISK kr1,216.28
List Price:  ISK kr1,703.28
You save:  ISK kr487
DH90.14
List Price:  DH126.24
You save:  DH36.09
L164.83
List Price:  L230.84
You save:  L66
ден522.82
List Price:  ден732.16
You save:  ден209.33
MOP$80.03
List Price:  MOP$112.08
You save:  MOP$32.04
N$173.38
List Price:  N$242.80
You save:  N$69.42
C$367.75
List Price:  C$514.99
You save:  C$147.24
रु1,407.90
List Price:  रु1,971.63
You save:  रु563.72
S/34.81
List Price:  S/48.75
You save:  S/13.93
K41.77
List Price:  K58.49
You save:  K16.72
SAR37.46
List Price:  SAR52.46
You save:  SAR15
ZK236.29
List Price:  ZK330.90
You save:  ZK94.61
L43.17
List Price:  L60.45
You save:  L17.28
Kč206.58
List Price:  Kč289.30
You save:  Kč82.71
Ft3,320.67
List Price:  Ft4,650.27
You save:  Ft1,329.60
SEK kr94.01
List Price:  SEK kr131.65
You save:  SEK kr37.64
ARS$14,731.68
List Price:  ARS$20,630.26
You save:  ARS$5,898.57
Bs69.05
List Price:  Bs96.70
You save:  Bs27.64
COP$38,972.51
List Price:  COP$54,577.11
You save:  COP$15,604.60
₡5,041.28
List Price:  ₡7,059.82
You save:  ₡2,018.53
L261.92
List Price:  L366.79
You save:  L104.87
₲71,161.74
List Price:  ₲99,654.93
You save:  ₲28,493.19
$U398.62
List Price:  $U558.23
You save:  $U159.61
zł36.26
List Price:  zł50.78
You save:  zł14.51
Already have an account? Log In
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

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.