Davide Sanchioni
Posted on:

08 Dec 2021
0

Create table employees_dup

in SQL / UNION vs UNION ALL

For the creation of employees_dup wasn't it better to use the statement create table employees_dup as select * from employees limit 20?

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
Joseph Skvarna
1
14
Resolved: employees.sql database not found in resources
Anna Znosko
0
12
Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Snoor Salihi
0
10
Resolved: Drop table from the database
Francois Chouinard
1
10
Can you show the instructions to reproduce dept_manager_dup table?
Matt Birch
0
10
Error after Error: Can't create a table this time