Concept explainers
DISTINCT Keyword: “DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column. The syntax for “DISTINCT” keyword is as follows:
Syntax:
SELECT DISTINCT column_Name FROM table_Name;
AND Operator:
In SQL, “AND” keyword is used in order to check two and more than two conditions. This usually works well with “WHERE” clause.
Syntax:
SELECT * FROM table_Name WHERE condition1 AND condition2;
ORDER BY Clause:
SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.
Syntax:
SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;
Trending nowThis is a popular solution!
Chapter 5 Solutions
A Guide to SQL
- Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.arrow_forwardAdd a new row in the ORDERS table with the following data: Order# = 1022, Customer# = 2000, and Order date = August 6, 2009. Describe the error raised and what caused the error.arrow_forwardAdd two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees date of termination.arrow_forward
- Create a list of each book title stored in the BOOKS table and the category in which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first.arrow_forwardWho has rented movies in Japanese language? Return only the first five distinct results in alphabetical order by last name.(Hints: In the language table, there is a field “name” that contains the film language names.) Display: first name and last namearrow_forwardUsing software.subscriptions table, pull all columns for subscriptions that have been cancelled.arrow_forward
- Repeat Task 5 without using the ITEM_INVOICE VIEW to retrieve the item ID, description, price, invoice number, invoice date, quantity, and quoted price for all items with a quoted price that exceed $100.arrow_forwardTask B. Import the data shown in pictures into the two tables created.arrow_forwardTask 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.arrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L