Vaibhav
Last answered:

28 Nov 2021

 Posted on:

09 Nov 2021
0

Regarding sql subqueries

in SQL / SQL Subqueries nested in SELECT and FROM

i can't understand how the subquery result is filled in all the rows of the table
please help

image

1 answers ( 0 marked as helpful)
Asmaa Abdulhamid
Posted on:

28 Nov 2021
0

Hi JEE
yes there is one manager (emp_no 110022) for 20 employees, and one more manager with emp_no (110039) for  20 employees more..

Submit an answer

related questions

Tahira
1
18
Resolved: sql installation
THOMAS BELL
1
16
14. SQL JOINs - Error Code: 1055 (only_full_group_by)
Yuvraj Shivaji Dhepe
0
14
SQL subqueries with WHERE clause.
Davide Sanchioni
0
14
Resolved: SQL Exam question number 29
Joseph Skvarna
1
14
Resolved: employees.sql database not found in resources
Anita vd Berg
1
10
Resolved: SQL: Foreign Key Constraint Part II
Ramsey Alizadeh
0
10
SQL’s Order Of Execution
Archisman Das
0
8
Resolved: SQL Task- getting the names of all the managers who have an AVG salary of 85k+