ubiq

Build dashboards & reports in minutes

  • Blog
  • What is Ubiq
  • Free Trial

How to Update Array in PostgreSQL

January 15, 2021January 15, 2021 Ubiq PostgreSQL
update array in postgresql

Sometimes you may need to update array in PostgreSQL with new data. In this article, we will look at how to change array in PostgreSQL, modify array in PostgreSQL, and merge arrays in PostgreSQL.

Continue reading


How to Get Multiple Counts With Single Query in MySQL

January 15, 2021January 15, 2021 Ubiq MySQL
get multiple count in mysql

Sometimes you may need to select multiple count in one query or get multiple counts for different criteria. Here is how to get multiple counts with single query in MySQL.

Continue reading


How to Convert datetime to UTC in MySQL

January 14, 2021January 14, 2021 Ubiq MySQL
convert datetime to utc in mysql

Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC in MySQL

Continue reading


How to Add column in Redshift

January 13, 2021January 13, 2021 Ubiq Redshift
how to add column in redshift

Sometimes you may need to add column in Redshift. Here is how to add column in Redshift database.

Continue reading


How To Add Column in SQL Server

January 13, 2021 Ubiq SQL Server
how to add column in sql server

Sometimes you may need to add column in SQL Server table. Here is how to add column in SQL Server.

Continue reading


How To Truncate Table in Redshift

January 12, 2021January 12, 2021 Ubiq Redshift
how to truncate table in redshift

Sometimes you may need to empty table in Redshift. Here is how to truncate table in Redshift.

Continue reading


How to Duplicate Table in SQL Server

January 12, 2021 Ubiq SQL Server
how to duplicate table in sql server

Sometimes you may need to copy table data, structure in SQL Server. Here is how to duplicate table in SQL Server.

Continue reading


How to Rename Table in Redshift

January 8, 2021January 8, 2021 Ubiq Redshift
rename table in redshift

Sometimes you may need to change name of database table in Redshift. Here is how to rename table in Redshift.

Continue reading


How To Truncate Table in SQL Server

January 7, 2021January 8, 2021 Ubiq SQL Server
truncate table in sql server

Sometimes you may need to empty table in SQL server. Here is how to truncate table in SQL Server.

Continue reading


How to Insert into Array in PostgreSQL

January 5, 2021January 5, 2021 Ubiq PostgreSQL
how to insert into array in postgresql

PostgreSQL allows you to select into array, append to array and insert array of objects. Here is how to insert into array in PostgreSQL.

Continue reading


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting tool that makes it easy to get insights from data. Build business dashboards, charts & reports in minutes.Try it Today!




  • Popular
  • Recent
  • transpose rows columns dynamically
    How to Transpose Rows to Columns Dynamically in MySQL Feb 12, 2020
  • calculate percentage of column in mysql
    How to Calculate Percentage of Column in MySQL Jan 6, 2020
  • calculate total sales per month in mysql
    How to Calculate Total Sales Per Month in MySQL? Mar 25, 2020
  • How to create a read-only MySQL user? Nov 25, 2013
  • get last record in each group
    How To Get Last Record In Each Group In MySQL May 27, 2020
  • calculate moving average mysql
    How to Calculate Moving Average in MySQL Feb 17, 2020
  • import csv to mysql workbench
    How to Import CSV to MySQL Workbench Apr 30, 2020
  • update array in postgresql
    How to Update Array in PostgreSQL Jan 15, 2021
  • get multiple count in mysql
    How to Get Multiple Counts With Single Query in MySQL Jan 15, 2021
  • convert datetime to utc in mysql
    How to Convert datetime to UTC in MySQL Jan 14, 2021
  • how to add column in redshift
    How to Add column in Redshift Jan 13, 2021
  • how to add column in sql server
    How To Add Column in SQL Server Jan 13, 2021
  • how to truncate table in redshift
    How To Truncate Table in Redshift Jan 12, 2021
  • how to duplicate table in sql server
    How to Duplicate Table in SQL Server Jan 12, 2021
dazzling Theme by Colorlib Powered by WordPress