Build dashboards & reports in minutes

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

MySQL

Single quotes, Double quotes and Backticks in MySQL

February 4, 2021March 11, 2021 Ubiq MySQL
single quotes, double quotes and backticks

MySQL supports using single quotes, double quotes and backticks. Here is when to use single quotes, double quotes and backticks in MySQL.

Continue reading


Difference between Inner join and Outer join in SQL

February 4, 2021March 11, 2021 Ubiq MySQL
inner join vs outer join

Inner join and outer join are useful to join database tables in SQL. Here is the difference between inner join and outer join in SQL.

Continue reading


How To Do a Full Outer Join in MySQL

February 3, 2021March 11, 2021 Ubiq MySQL
get full outer join in mysql

MySQL does not support full outer joins. Here is how to do a full outer join in MySQL.

Continue reading


How To Get row_number in MySQL

February 3, 2021March 11, 2021 Ubiq MySQL
how to get row number in mysql

Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.

Continue reading


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


Posts navigation

Older posts

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