Ubiq, Author at Ubiq Database Blog

How to Get Last Row Per Group in PostgreSQL

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.

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.

Sometimes you may need to convert time from one timezone to another. Here’s how to change MySQL timezone in query.

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 allows you to create stored procedure and functions in PostgreSQL. Here’s how to use PostgreSQL create function.

PostgreSQL Create Schema allows you to create database schema in PostgreSQL. Here’s how to create schema in PostgreSQL.

Sometimes you may need to show indexes in MySQL. Here’s how to list all indexes using MySQL SHOW INDEX command.

September 3, 2020 Ubiq MySQL

Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.

September 3, 2020 Ubiq PostgreSQL

Many times you may need to create database in PostgreSQL. Here’s how to create database in PostgreSQL using PostgreSQL CREATE DATABASE command.

Sometimes you may need to create table in PostgreSQL. Here’s how to create table using PostgreSQL Create table query.