Concept explainers
“SELECT” command:
The “SELECT” command is used to retrieve data in a
Syntax for selecting values from the table is as follows:
SELECT STUDENT_ID FROM STUDENT;
- The given query is used to display each student ID from “STUDENT” table.
“IN” Clause:
- The “IN” clause consists of an “IN” operator followed by a set of values.
- Using an “IN” clause, user can determine whether a column contains one of a particular group of values.
Example:
The example for “IN” clause is given below:
SELECT STUDENT_ID, STUDENT_NAME, STUDENT_CREDIT FROM STUDENT WHERE STUDENT_CREDIT IN(50, 70, 100);
The above query is used to list student ID, name, and credit for each student with a credit limit of “50”, “70” or “100”.
- From the given query, user can determine whether a student credit limit is “50”, “70” or “100” using an “IN” operator.
“ORDER BY” Clause:
- User can sort the data in specific order using “ORDER BY” clause.
- The column on which to sort data is called a sort key or a simple key.
- To sort the output, use an “ORDER BY” clause followed by the sort key.
- If the user does not indicate a sort order, the output displayed in default order that is ascending order.
Example:
The example for “ORDER BY” clause is given below:
SELECT STUDENT_ID, STUDENT_NAME, STUDENT_CREDIT FROM STUDENT ORDER BY STUDENT_CREDIT;
The above query is used to list student ID, name and credit for each student with ascending order of student credit using an “ORDER BY” clause.
- From the given query, the sort key is “STUDENT_CREDIT”. So, the rows are sorted in ascending order by “STUDENT_CREDIT”.
“DESC” Operator:
- User can sort the data in descending order using a “DESC” operator.
- To sort in descending order, user follows the name of the sort key with the “DESC” operator.
Example:
The example for “DESC” operator is given below:
SELECT STUDENT_ID, STUDENT_NAME, STUDENT_CREDIT FROM STUDENT ORDER BY STUDENT_CREDIT DESC;
The above query is used to list student ID, name and credit for each student with descending order of student credit using an “ORDER BY” clause with “DESC” operator.
- From the given query, the sort key is “STUDENT_CREDIT”.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
A Guide to SQL
- An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.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
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage