Skip to content

Instantly share code, notes, and snippets.

@akshaykhale1992

akshaykhale1992/Queries.sql

Last active September 30, 2019 05:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save akshaykhale1992/22448e265e646c5143ec2725d0358549 to your computer and use it in GitHub Desktop.
Save akshaykhale1992/22448e265e646c5143ec2725d0358549 to your computer and use it in GitHub Desktop.
Download ZIP
Queries of Medium Article:
Raw
Queries.sql
/* Query to find all the Active Users
* (if you are using `deactivated_on` date field with default NULL
*/
SELECT *
FROM `users`
WHERE `deactivated_on` IS NULL
/* Query to find all the In-Active Users
* with the date when they were deactivated
*/
SELECT *
FROM `users`
WHERE `deactivated_on` IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment