Sometimes you may need to get last row of table or last row per group in PostgreSQL. Here’s how to get last record of each group in PostgreSQL.
How to Get Last Row Per Group in PostgreSQL
How To Rank Over Partition in MySQL
Sometimes you may need to rank over partition in MySQL or do grouped ranking in MySQL. Here’s how to do it with MySQL Rank partition function.
CONVERT_TZ – How To Change MySQL Timezone in Query
Sometimes you may need to convert time from one timezone to another. Here’s how to change MySQL timezone in query.
How To Change MySQL Server Time Zone
Sometimes you may need to change MySQL server time zone to UTC or change timezone in cPanel. Here’s how to change MySQL server time zone.
PostgreSQL Create Function
PostgreSQL create function allows you to create stored procedure and functions in PostgreSQL. Here’s how to use PostgreSQL create function.
PostgreSQL Create Schema
PostgreSQL Create Schema allows you to create database schema in PostgreSQL. Here’s how to create schema in PostgreSQL.
MySQL Show Indexes in Database
Sometimes you may need to show indexes in MySQL. Here’s how to list all indexes using MySQL SHOW INDEX command.
MySQL Compare Databases
Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.
PostgreSQL Create Database
Many times you may need to create database in PostgreSQL. Here’s how to create database in PostgreSQL using PostgreSQL CREATE DATABASE command.
PostgreSQL CREATE TABLE
Sometimes you may need to create table in PostgreSQL. Here’s how to create table using PostgreSQL Create table query.
