Catalog
Full catalog
Resources
Blog
University
Guide
Bootcamps
Provided by
JetBrains Academy
Creators of the most popular IDEs:
IntelliJ IDEA, PyCharm
& others
Authors of
Kotlin
,
Google's preferred language
for Android
More than
11.4 million developers and 300,000 companies worldwide
use JetBrains IDEs to create their products
Pricing
For Business
Sign in
Start for free
Computer science
Fundamentals
SQL and Databases
Basics SQL
Data Modification Language
Inserting selected rows
Suggested problems
Syntax is important
Check all conditions
Is it true
Make it work
New job
Only names
Orders
Skip topic
Theory
Syntax is important
Report a typo
Select all syntactically correct queries.
Select one or more options from the list
Get unstuck
Comments
Get help from the community
Code snippets
See topic-related syntax examples
INSERT INTO employees (name) SELECT name FROM candidates
INSERT INTO employees SELECT * FROM candidates
INSERT INTO employees SELECT * FROM candidates WHERE id = 1
INSERT INTO employees FROM candidates WHERE name = 'John Smith'
201
learners liked this problem.
7
didn't like it.
What about you?
___
Create a free account to access the full topic
Sign up with Google
Sign up with GitHub
Sign up with JetBrains Account
Sign up with email
By continuing, you agree to the
JetBrains Academy Terms of Service
as well as
Hyperskill Terms of Service and Privacy Policy
.
Comments (6)
Hints (4)
Useful links (2)
Show discussion