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

Author: Ubiq

How to Get Data For Every Hour in MySQL

February 2, 2021February 2, 2021 Ubiq MySQL
get hourly data in mysql

Sometimes you may need to get data for every hour, or retrieve hourly data in MySQL. Here is how to get data for every hour in MySQL.

Continue reading


How To Get Last 1 Hour Data in MySQL

February 2, 2021February 2, 2021 Ubiq MySQL
get last 1 hour data in mysql

It is useful to fetch last 1 hour rows or retrieve last 1 hour records. Here is how to get last 1 hour data in MySQL.

Continue reading


How to Show Rows Not Present in Another Table in MySQL

February 1, 2021February 1, 2021 Ubiq MySQL
show records not present in another table

Sometimes you may need to find rows not present in another table or select rows not present in another table. Here is how to show rows not present in another table in MySQL.

Continue reading


How to Get Current Week Data in MySQL

February 1, 2021February 1, 2021 Ubiq MySQL
get current week data in mysql

It is useful to get current week records or fetch this week records in MySQL. Here is how to get current week data in MySQL.

Continue reading


Select Top 10 Records for Each Category in MySQL

January 29, 2021January 29, 2021 Ubiq MySQL
select top 10 records

Sometimes you may need to select top n records for each category. Here is how to select top 10 records for each category in MySQL.

Continue reading


Common Table Expression in MySQL

January 28, 2021January 28, 2021 Ubiq MySQL
common table expression in mysql

Common Table Expressions allow you to easily write complex SQL queries in MySQL. Here is how to create common table expressions in MySQL.

Continue reading


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


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting software. Build business dashboards, charts & reports in minutes.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

Resources

  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress