SQL Question 5 Examine the table below and write the SQL command that will displ
ID: 3745320 • Letter: S
Question
SQL
Question 5
Examine the table below and write the SQL command that will display all the products from the products table where the price is more than $40
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
Question 6
What SQL command is used to show only different values (no repeats)
Question 7
Take a look at the table below. Write the SQL command that will display all the records from the products table where the price is $23.00
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
Question 8
What SQL command show only those records that fit a specific criteria
Question 9
Choose the SQL statement that will select all the columns from a table named "Owners"?
Question 10
Select the SQL command that will find and display data from a table
Examine the table below and write the SQL command that will display all the products from the products table where the price is more than $40
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
Explanation / Answer
5)The SQL command that will display all the products from the products table where the price is more than $40 is
SELECT ProductName
FROM Products
WHERE Price>$40
here in the above query SELECT displays the names of the products whose price is greater than $40
and FROM command is used to specify from which table we are selecting and WHERE command is used to specify the condition Price>$40.
6)SELECT DISTINCT is the command that is used to select the distinct values from the given table columns.
The syntax for the SELECT DISTINCT command is
SELECT DISTINCT c1,c2
FROM table1
7)The SQL command that will display all the products from the products table where the price is more than $40 is
SELECT ProductName
FROM Products
WHERE Price>$23
here SELECT displays the names of the products whose price is greater than $23
and FROM command is used to specify from which table we are selecting and WHERE command is used to specify the condition Price>$23.
8) SELECT displays the specific column or all the columns in a table and
and FROM command is used to specify from which table we are selecting and WHERE command is used to specify the condition that is the specific criteria from which we want to is specified using WHERE class.
9)SELECT * is the SQL command that is used to select the all the fields in a table
SELECT * FROM Owners
The above query will select all the columns from a table named "Owners".
10)SELECT displays the specific column or all the columns in a table and
and FROM command is used to specify from which table we are selecting and WHERE command is used to specify the condition that is the specific criteria from which we want to is specified using WHERE class.The conditonal statements is specified in WHERE class
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.