An Overview of the SQL Query Clauses and Functions
Last Updated on July 26, 2023 by Editorial Team
Author(s): Rashida Nasrin Sucky
Originally published on Towards AI.
Can be used as a cheat sheet
Photo by Ignacio Amenábar on Unsplash
This member-only story is on us. Upgrade to access all of Medium.
SQL is probably the most widely used tool in the world of Data Science, Analysis, or Engineering. In most job postings SQL is one of the common requirements. There are a lot of tutorials and articles available as well. I decided to make a collection of SQL select queries, clauses, and common inbuilt functions. Experienced SQL users may already have all these commands memorized. But it should be helpful for new grads who are looking for jobs to help with their interviews or recent… Read the full blog for free on Medium.
Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.
Published via Towards AI
Take our 85+ lesson From Beginner to Advanced LLM Developer Certification: From choosing a project to deploying a working product this is the most comprehensive and practical LLM course out there!
Towards AI has published Building LLMs for Production—our 470+ page guide to mastering LLMs with practical projects and expert insights!

Note: Content contains the views of the contributing authors and not Towards AI.
Disclosure: This website may contain sponsored content and affiliate links.
Towards AI has built a jobs board tailored specifically to Machine Learning and Data Science Jobs and Skills. Our software searches for live AI jobs each hour, labels and categorises them and makes them easily searchable. Explore over 10,000 live jobs today with Towards AI Jobs!
🔥 Recommended Articles 🔥
Why Become an LLM Developer? Launching Towards AI’s New One-Stop Conversion CourseTesting Launchpad.sh: A Container-based GPU Cloud for Inference and Fine-tuningThe Top 13 AI-Powered CRM PlatformsTop 11 AI Call Center Software for 2024
Learn Prompting 101—Prompt Engineering Course
Explore Leading Cloud Providers for GPU-Powered LLM Training
Best AI Communities for Artificial Intelligence Enthusiasts
Best Workstations for Deep Learning
Best Laptops for Deep Learning
Best Machine Learning Books
Machine Learning Algorithms
Neural Networks Tutorial
Best Public Datasets for Machine Learning
Neural Network Types
NLP Tutorial
Best Data Science Books
Monte Carlo Simulation Tutorial
Recommender System Tutorial
Linear Algebra for Deep Learning Tutorial
Google Colab Introduction
Decision Trees in Machine Learning
Principal Component Analysis (PCA) Tutorial
Linear Regression from Zero to Hero