This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: order by is followed by the keyword desc. You can sort the query results by more than 1 column. Lets list students sorted by grade and instructor id. Display how many rows are in the dbst651_students table. You can define the column alias names. Notice that count(*) heading is replaced with STUDENTCOUNT heading. Think about: 1. What if I want to select data from more than one table? How would I list student names and the corresponding instructor names in the same report? 2. What if I want to display how many students got each letter grade? 3. Is it possible to specify more than one criterion in the where clause? What if I want to list students who have an A and take a class taught by Yelena? These topics will be covered later in the course....
View Full Document
This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.
- Spring '09
- Yelena - TA