Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
12. What are the SQL aggregate functions? 13. How do you avoid including duplicate values in a query's results? 14. What is a subquery?

12. What are the SQL aggregate functions? 13. How do you avoid including duplicate values in a query's results? 14. What is a subquery?

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Need help with this

CRITICAL THINKING Single-Table Queries 12. What are the SQL aggregate functions? 13. How do you avoid including duplicate values in a query's results? 14. What is a subquery? 15. How do you group data in an SQL query? 16. When grouping data in a query, how do you restrict the output to only those groups satisfy- ing some condition? 17. How do you find rows in which a particular column contains a null value? 18. Use the Internet to research the SQL [charlist] wildcard that is available in Oracle and SQL Server. Using the information you find, complete the following SQL command to find all cit- ies that begin with the letters "C" or "G." SELECT CUSTOMER_NAME, CITY FROM CUSTOMER WHERE CITY LIKE Be sure to cite the URL(s) that provided the information. 129
Transcribed Image Text:CRITICAL THINKING Single-Table Queries 12. What are the SQL aggregate functions? 13. How do you avoid including duplicate values in a query's results? 14. What is a subquery? 15. How do you group data in an SQL query? 16. When grouping data in a query, how do you restrict the output to only those groups satisfy- ing some condition? 17. How do you find rows in which a particular column contains a null value? 18. Use the Internet to research the SQL [charlist] wildcard that is available in Oracle and SQL Server. Using the information you find, complete the following SQL command to find all cit- ies that begin with the letters "C" or "G." SELECT CUSTOMER_NAME, CITY FROM CUSTOMER WHERE CITY LIKE Be sure to cite the URL(s) that provided the information. 129
7. What wildcards are available in Oracle, and what do they represent? 8. How do you determine whether a column contains one of a particular set of values without using an AND condition? 9. How do you sort data? 10. How do you sort data on more than one sort key? What is the more important key called? What is the less important key called? 11. How do you sort data in descending order?
Transcribed Image Text:7. What wildcards are available in Oracle, and what do they represent? 8. How do you determine whether a column contains one of a particular set of values without using an AND condition? 9. How do you sort data? 10. How do you sort data on more than one sort key? What is the more important key called? What is the less important key called? 11. How do you sort data in descending order?
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS