|
This example illustrates use of ORDER BY clause.
The query lists all events and venues where they take place. Result dataset is sorted by ticket price (ascending) and venue name (descending order).
select e1."Event_Name", v2."Venue", e1."Ticket_price"
from "events" e1, "venues" v2
where (e1."VenueNo" = v2."VenueNo")
order by e1."Ticket_price" asc, v2."Venue" desc
Download Absolute Database | Learn more |
|
|
Current version: 7.95
Released: February 08, 2023
Price: $ 149
 
|
|
|
Thanks again for the superb tech support, I was worried I'd hit a brick wall this close to the finish line. Even working on the weekend... you guys rock!!!
Bob Boyd
|
|
|
