
224 ◾ Cloud Database Development and Management
and RANK. e RANK function returns the rank for each record in a result set from a query.
For example, Figure 6.49 shows that the classrooms in each building are ranked based on their
capacities. e ranking of capacities is in a descending order per building.
By now, you have learned how to use various built-in functions in query statements. e SQL
Database function library includes many other built-in functions. A complete coverage of the
built-in functions is beyond the scope of this book. You can find more information about the
built-in functions through the SQL Database Help menu. Besides t ...