SQL Essential Queries

SQL Essential Queries

  • Find number of rows between two dates

    SELECT COUNT(customer_id) FROM customer_table where created_at BETWEEN '2021-01-07 00:00:00' AND '2021-01-14 00:00:00';
    
  • List all columns of a table

    show columns from customer_table
    
  • Get all tables

    show tables
    
  • Get table schema

    show create table customer_table;
    

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: