#24 New Companies | HackerRank SQL Solutions #sql #oracle #pivot #hackerrank #coding #programming

preview_player
Показать описание
Please join telegram group for queries...

Please follow us

Thanks for watching us ...
Dev19🖤
  1. DEV19
  2. #C #C #JAVA #Python #Hackerrank #Code #Programm
Рекомендации по теме
#24 New Companies 0:12:35

#24 New Companies | HackerRank SQL Solutions #sql #oracle #pivot #hackerrank #coding #programming

New Companies | 0:20:05

New Companies | 24/100 Days Of SQL Challenge | HackerRank Solutions

Hackerrank New Companies 0:06:32

Hackerrank New Companies | Multiple Tables | Sql Interview

Hackerrank SQL Solutions 0:26:00

Hackerrank SQL Solutions | SQL Hackerrank New Companies Medium Problem SOLVED

SQL Hackerrank Solutions 0:14:58

SQL Hackerrank Solutions | Hackerrank New Companies

Hackerrank The Company 0:08:20

Hackerrank The Company Problem | SQL | Ashutosh Kumar

SQL HackerRank Solutions 0:14:58

SQL HackerRank Solutions | Hackerrank New Companies query

New Companies 0:02:52

New Companies HackerRank SQL

Hackerrank SQL Solution 0:05:18

Hackerrank SQL Solution #3 Intermediate SQL - New Companies

ALL Hackerrank SQL 7:28:13

ALL Hackerrank SQL Solutions in ONE Video! | Easy Medium Hard Problems

Hackerrank SQL Solutions 0:07:14

Hackerrank SQL Solutions - New Companies - Level Medium

New Companies - 0:10:19

New Companies - Part One | SQL Interview Question | HackerRank Intermediate

New Companies | 0:02:56

New Companies | #datawithjoy | HackerRank Solution | SQL

HACKER RANK (SQL 0:12:52

HACKER RANK (SQL PROBLEM) NEW COMPANIES | URDU / HINDI

Girls Hostel Madness😂❤️ 0:00:11

Girls Hostel Madness😂❤️ #shorts #short #girls #hostellife

Advice from the 0:10:21

Advice from the Top 1% of Software Engineers

How much does 0:00:33

How much does a SOFTWARE DEVELOPER make?

Coding for 1 0:00:24

Coding for 1 Month Versus 1 Year #shorts #coding

How I learned 0:11:28

How I learned to code in 3 months and cracked Google and Amazon

Frontend Developer vs 0:00:11

Frontend Developer vs Backend Developer vs Fullstack Developer

New Python Coders 0:02:13

New Python Coders Be Like...

My Brain after 0:07:50

My Brain after 569 Leetcode Problems

Sukoon❤️ My CA 0:00:11

Sukoon❤️ My CA Intermediate result! Cleared my first group🔥 #castudentlife #resultreaction #cainter...

Easiest Programming language 0:00:30

Easiest Programming language to start with to earn money

Комментарии
Автор

max kyu lagaya ka answer ye hai ki wo string output deta to max min sum lagaane pe wo group function jese work karega aur output same dega kyuki neeche group function diya tha

vivekpanchbhai
Автор

wHY WE use MAX aggregate funcction in founder from employee e

mdamirhussain
Автор

why did u use max(founder)?? what is the role of max here

sargunsingh
Автор

Nice Explanation, but I want to know why you used MAX function. I know the use of MAX function, but why we used it here, since we only want founder name.

I've also seen other problems where people use any aggregate function even though it is not required just to get the answer. There's definitely some reason behind it.

Can you please explain me that reason Bro !!!

ahmadhamzakhan
Автор

why was max(founder) used? Can you explain?

vaibhavichitnis
Автор

select C. company.
code,
C. Founder,
(select count(distinct lead_manager.
_code)
from Lead_Manager as L where L. Company_code =
C.company_code),
(select count distinct senior_ manager.
_code)
from senior manager as s
where s.company_code = c. company_code),
(select count (distinct Manager-_code)
from manager as M where M. company_ code =
C. company _code),
select count distinct
Employee code
From Employee as E where E. company_code.
C.company_ code
or Company as C order
C. company code ase:

bnavaneethakrishnan