SQL Basics - SQL online course | LearnSQL.com

PHOTO

Tue Aug 09 2022 08:19:41 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy

SELECT  department,count(*) as employees_no
FROM employees
WHERE year=2013
GROUP BY department

group by and where.Where comes first followed by groupby

https://learnsql.com/track/sql-from-a-to-z/course/sql-queries/order-by-group-by/group-by/group-by

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SQL

@vnmshenoy

SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com SQL Basics - SQL online course | LearnSQL.com select year from date interesting having clause eg order by the summed value groupby full query SQLLearn All/Any operator-really interesting SQL Basics - SQL online course | LearnSQL.com Find Out How To Use Filtering In SQL JOINs - Vertabelo Academy Online Interactive Course Improve Your Knowledge By Learning SQL Multiple JOINs - Vertabelo Academy Online Interactive Course Learn How To Use SQL JOINs To Self JOIN Tables - Vertabelo Academy Online Interactive Course Improve Your Skills By Learning Non-Equi Self JOIN - Vertabelo Academy Online Interactive Course Learn How To Use Non-Equi SQL JOINs -We also don't have to use the equality operator when joining tables. We are free to use other comparison operators (<, >, <=, >=, !=, <>) or the BETWEEN operator: use of MOD(patient.id, 2) = 1 . if you need to find odd id's instead of say using in (1,3,5,7,....) use Mod what i liked about this is that the answer provided had used "AND" between joins as well Multiple Filtered SQL JOIN - Vertabelo Academy Online Interactive Course Multiple Non-Equi JOINs Practice - self join table pe join on non-equi join and not primary key concatenation operator || (doesnt work on all DBs) Inbuilt SQL functions

Browse more snippets >>