Learn
Courses
Career Tracks
Upcoming Courses
Certificates
Career Track Certificate
Course Certificate
Resources
All Resources
Course Notes
Templates
Infographics
Career Guides
Practice Exams
Blog
Success Stories
Pricing
Business
Team Plan
Live Trainings
Log In
Sign Up
Follow this topic
Share
Eslam Mohamed Helmi
Last answered:
08 Feb 2023
Posted on:
07 Feb 2023
0
Another Solution Using COALESCE
in
SQL
/
SQL Subqueries nested in SELECT and FROM
1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:
08 Feb 2023
0
Submit an answer
Submit answer
related questions
Rhys Morgan
2
28
Rollback not reverting DB state after using INSERT INTO
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
kfir ben galil
0
10
Resolved:
using the exists key word
Amadi Bethel
0
8
IFNULL & COALESCE FUNCTIONS NOT IN MY WORKBENCH
Saeed Ehsanfar
0
6
Need clarification on why using e.emp_no < 10011 in the WHERE clause
Meenakshi Akila P.S
0
6
using aliases in order by clause
Jose Luis Loren
3
6
Alternative code using group by
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table