+ 11

Is SQL okay to learn?

22nd Jul 2020, 5:20 AM
Priya Sharma :)
Priya Sharma :) - avatar
8 odpowiedzi
+ 2
SQl ok
26th Jul 2020, 8:53 AM
ThaeThaeMar
+ 5
Post only Programming related questions and doubts please.
22nd Jul 2020, 5:47 PM
A S Raghuvanshi
A S Raghuvanshi - avatar
+ 3
Easy to learn too
22nd Jul 2020, 6:10 AM
Jyothirani
Jyothirani - avatar
+ 3
You are trying to retrieve from this simple complex query country_name_eng field from country table in ascending order.
23rd Jul 2020, 5:52 AM
Jyothirani
Jyothirani - avatar
+ 2
Sql is best Priya Sharma but. Don't end with basic
22nd Jul 2020, 5:24 AM
Sâgærāvürï
Sâgærāvürï - avatar
+ 2
Jothirani can u explain this SELECT country.country_name_eng, COUNT(city.id) AS number_of_cities FROM country LEFT JOIN city ON country.id = city.country_id GROUP BY country.id, country.country_name_eng ORDER BY country.country_name_eng ASC;
22nd Jul 2020, 6:15 AM
Sâgærāvürï
Sâgærāvürï - avatar
+ 2
Yes
23rd Jul 2020, 3:39 PM
shubham kumar
shubham kumar - avatar
+ 2
Yes
26th Jul 2020, 8:52 AM
ThaeThaeMar