![]() To find the longest time of all tracks, you use the MAX() function as follows: SELECT MAX(Milliseconds) / 60000 Minutes FROM The following example uses the SUM() function to calculate the length of each album in minutes: SELECTĬode language: SQL (Structured Query Language) ( sql ) SQLite MAX() function example Track_count DESC Code language: SQL (Structured Query Language) ( sql ) SQLite SUM() function example To find the albums and their corresponding track count, you use the following statement: SELECT The following statement returns the number of rows from the tracks table: SELECT COUNT(*)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |