Concept explainers
Display values from table:
The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML).
The Syntax to view the contents using asterisk (*) is as follows:
SELECT * FROM table_Name;
Selective columns can also be retrieved by replacing all the column(s) names in place of the asterisk symbol.
WHERE Statement:
“WHERE” statement is used limit the number of rows. For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red.
SELECT * FROM FTable WHERE color = 'red';
When the above statement is executed, red colored fruits get displayed.
IS NULL operator:
“IS NULL” operator is used to get values from the column(s) in which the condition is equal to “NULL”.
Syntax:
SELECT * FROM table_Name WHERE column_Name IS NULL;
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Database Concepts (8th Edition)
- Write an SQL statement to display the name and breed of all pets, sorted by PetName.arrow_forwardWhat SQL statement function is used to generate a column, where the value for the new column is dependant on another column's value for the row of data (i.e SQL IF statement)?arrow_forwardWrite SQL statements to the following queries. Retrieve customer FULL_NAME which full name (starts with uppercase letter N and end with lowercase letter i) or (starts with uppercase letter K and end with lowercase letter d) in ascending order of FULL_NAME.arrow_forward
- Create a SQL statement to Display the number of clients for each CType with having less than 2 clients in the CLIENTS table.arrow_forwardWrite SQL statements for the following queries: Retrieve First_Name , Salary, department Name and Location_Name for all employees sorted by department Name.arrow_forwardWrite an SQL statement to display the PetBreed column of PET.arrow_forward
- Write SQL queries for the following. Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator. Display full name of doctors whose first name is other than Tania. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’ Display details of those male patients whose age is 25 or 36. Display details of those patients whose name contains less than 5 characters. Display first 4 doctors who are earning least salary. Display details of all patients in such a way that female patients are shown before male patients. Display the unique cities from doctor table. Display all…arrow_forwardwrite an sql query that displays the parking space number location as well as the name of the staff member to whom the parking space has been allocatedarrow_forwardWrite SQL queries for the following. Display full name of doctors whose first name is other than Tania. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’arrow_forward
- Show the product names for products that have been ordered in quantities equal to or exceeding 120. Use a non-correlated subquery in the SQL statement.arrow_forwardWrite an SQL statement to display all columns of all rows of PET. Do not use the asterisk (*) notationarrow_forwardFrom the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005arrow_forward
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningDatabase 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 Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr