Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

How To Calculate Margin In MySQL

January 26, 2021January 26, 2021 Ubiq MySQL
calculate margin in mysql

It is important to calculate profit for every business. Here is how to calculate margin in MySQL.

Continue reading


MySQL Query To Get Top Selling Products

January 26, 2021January 26, 2021 Ubiq MySQL
get top selling products in mysql

It is important to get top selling products for every ecommerce business. Here is the MySQL query to get top selling products.

Continue reading


Multiple Counts with Different Conditions in single MySQL query

January 25, 2021January 26, 2021 Ubiq MySQL
multiple counts with different criteria mysql

It is easy to get multiple counts with multiple conditions in MySQL. Here is how to get multiple counts with different criteria in MySQL.

Continue reading


How to Use CASE Statement in MySQL

January 25, 2021January 25, 2021 Ubiq MySQL
mysql case statement

Case statements help you use multiple if conditions in SQL queries. Here is how to write case statement in MySQL.

Continue reading


How to Check if PostgreSQL Array Contains Value

January 19, 2021January 28, 2021 Ubiq PostgreSQL
check value in postgresql array

Sometimes you may need to check if value exists in array. Here is how to check if PostgreSQL array contains value.

Continue reading


How to Use Coalesce in MySQL

January 19, 2021January 19, 2021 Ubiq MySQL
coalesce in mysql

Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.

Continue reading


How to Query JSON column in MySQL

January 18, 2021January 18, 2021 Ubiq MySQL
query json column in mysql

Sometimes you may need to search JSON array of objects, extract JSON data or retrieve JSON data in MySQL. In this article, we will look at how to query JSON column in MySQL.

Continue reading


How To Avoid Inserting Duplicate Records in MySQL

January 18, 2021January 18, 2021 Ubiq MySQL
avoid inserting duplicate records in mysql

Sometimes you may need to prevent duplicate insert while adding rows. Here is how to avoid inserting duplicate records in MySQL.

Continue reading


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 25, 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


Page 2 of 24«12345...1020...»Last »

About Us



Ubiq is a business intelligence & reporting software. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Reporting Tools
  • PostgreSQL Reporting Tools
  • Online Reporting Tools
  • Web Reporting Tools
  • Redshift BI Reporting
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • BI Reporting Software
  • MySQL BI Reporting Tools
  • Self Service BI
  • SaaS BI
Data Visualization
  • Data Visualization Tools
  • Data Analysis Tools
  • Visual Analytics
  • MySQL Charts
  • MySQL Graph Generator
  • MySQL Report Builder
  • Online Report Generator
  • Redshift Data Visualization
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software
  • Dashboard Creator
  • KPI Dashboard Software
Quicklinks
  • Contact Us
  • Docs
  • Jobs
  • BI Blog
  • Database Blog
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress