Tag: SQL FAQs

How to use the command line to import SQL files in MySQL?

How to use the command line to import SQL files in MySQL?

This can be done simply by following the below steps: Open MySQL Command Line Insert the user name and the password mysql > use your_database; mysql > source file_path_with_file_name.sql Below is the screenshot of importing create_tables.sql SQL file located at “D:\” drive in “sakila” Database.     Sign up for a 14-day trial of Datameer […]

  • SQL FAQs
  • December 16, 2018
What are the main differences between NOT IN vs NOT EXISTS in SQL?

What are the main differences between NOT IN vs NOT EXISTS in SQL?

The SQL operator NOT IN and NOT EXISTS may seem similar at first glance, but there are differences between them.  Let us set up the tables ‘orders’ and ‘order_details’ as below: CREATE TABLE orders (     order_id INT,     customer_name VARCHAR(100),     order_date DATETIME,     total_orders INT ); INSERT INTO  orders […]

  • SQL FAQs
  • December 16, 2018
How to find the duplicate data in a table in SQL?

How to find the duplicate data in a table in SQL?

Let us set up a ‘customers’ table with their email addresses: CREATE TABLE customers (     customers_id INT,     customer_name VARCHAR(100),     email VARCHAR(100) ); INSERT INTO  customers SELECT 1, ‘Jack’, ‘jack@email.com’ UNION ALL SELECT 2, ‘July’, ‘jack@email.com’ UNION ALL SELECT 3, ‘John’, ‘john@email.com’ UNION ALL SELECT 4, ‘Rose’, ‘rose@email.com’; We can […]

  • SQL FAQs
  • December 16, 2018
How to UPDATE a table by joining multiple tables in SQL?

How to UPDATE a table by joining multiple tables in SQL?

Let’s create the two tables ‘order’ and ‘order_detail.’ We can update the data of a table using conditions of other joined tables. It is possible to join two or more tables in an UPDATE query. CREATE TABLE orders (     order_id INT PRIMARY KEY,     customer_name VARCHAR(100),     order_date DATETIME,     total_orders INT […]

  • SQL FAQs
  • December 16, 2018
What are the main differences between UNION and UNION ALL in SQL?

What are the main differences between UNION and UNION ALL in SQL?

The main differences between UNION and UNION ALL are: a) UNION combines the two datasets into one and then removes the duplicate data UNION ALL combines the two datasets into one and but do not removes the duplicate data; b) Since the UNION ALL do not removes duplicate data, its performance is better than that […]

  • SQL FAQs
  • December 16, 2018
In SQL, how to limit the number of rows after ordering it in Oracle DB?

In SQL, how to limit the number of rows after ordering it in Oracle DB?

We can perform ‘Like’ operations in MongoDB using regular expressions. In fact, regular expressions are more powerful than the Like operator.  Let us consider the following collection: db = {   “fruits”: [                 {“name”: “apple” },                 { “name”: “pineapple” […]

  • SQL FAQs
  • December 16, 2018

Subscribe for the Latest Posts

Search

Download our Ebook on Data Collaboration

Featured Blog Posts

Datameer Partners with Google Cloud to Deliver Scalable, Secure Migration of Enterprise Data and Analytics Workloads to the Cloud
Datameer Partners with Google Cloud to Deliver ...

The partnership will help customers build secure pipelines to Google Cloud and run petabyte-scale...

  • Press Release
  • December 2, 2020
Datameer Spotlight disrupts the traditional centralized data warehouse model, giving organizations highly secure data access at a fraction of the cost.
Datameer Spotlight disrupts the traditional cen...

The new flagship product from Datameer upends a three-decade-old approach to data analytics SAN F...

  • Press Release
  • December 1, 2020
The Role of Chief Data Officers (CDOs) in 2020
The Role of Chief Data Officers (CDOs) in 2020

The role of Chief Data Officers (CDOs) in 2020 is evolving as CDOs are having quite possibly thei...

  • John Morrell
  • October 20, 2020
READ ALL