Build dashboards & reports in minutes

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

How to Compare Two Tables in MySQL

August 13, 2020 Ubiq MySQL
compare two tables mysql

Sometimes you may need to compare two tables in MySQL to find unmatched records or matched records. Here’s how to compare two tables in MySQL.

Continue reading


How To Get Last One Month Data in MySQL

August 10, 2020August 10, 2020 Ubiq MySQL
get last one month data mysql

Sometimes you may need to fetch last month record or get rows from previous month. Here’s how to get last one month data in MySQL.

Continue reading


How To Copy Table in MySQL

August 7, 2020August 7, 2020 Ubiq MySQL
how to copy table in mysql

Sometimes you may need to copy table in MySQL or clone table in MySQL. Here’s how to copy table in MySQL.

Continue reading


How To Add NOT NULL Constraint in MySQL

August 6, 2020August 6, 2020 Ubiq MySQL
mysql add not null constraint

Sometimes you may need to add NOT NULL constraint in MySQL. Here’s how to add NOT NULL constraint in MySQL.

Continue reading


How To Add Default Constraint in MySQL

August 5, 2020August 5, 2020 Ubiq MySQL
mysql add default constraint

Sometimes you may need to add default value to column or add column with default value in MySQL. Here’s how to add default constraint in MySQL.

Continue reading


How to Select Top N Rows Per Group in MySQL

August 4, 2020January 29, 2021 Ubiq MySQL
mysql select top n rows per group

Sometimes you may need to select top n rows per group in MySQL. Here’s how to select to n rows from each category in MySQL.

Continue reading


How to Get Last Week Data in MySQL

August 3, 2020August 3, 2020 Ubiq MySQL
get last week data mysql

Sometimes you may need to fetch last week data in MySQL. Here’s how to get last week data in MySQL for reporting and analysis.

Continue reading


MySQL Copy Database

July 31, 2020July 31, 2020 Ubiq MySQL
myql copy database

Sometimes you may need to copy database or clone database in MySQL. Here’s how to copy database in MySQL.

Continue reading


MySQL Insert Into Select

July 30, 2020July 30, 2020 Ubiq MySQL
MySQL Insert into select

Did you know that you can use SELECT statement to insert values into table? Here’s how to use MySQL INSERT INTO SELECT statement to quickly populate tables.

Continue reading


MySQL Select Top N Rows

July 29, 2020July 29, 2020 Ubiq MySQL
mysql select top n rows

Sometimes you may need to select top 10 rows or select top 1 row in MySQL. Here’s how to select top N rows in MySQL.

Continue reading


Page 12 of 24« First«...1011121314...20...»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