The MAX() function collects all the values of the expression mentioned in it and adds them up, which is further divided by the number of values or expressions that were added to find out the final greatest value. When where clause is used, only filtered out data is considered for the greatest calculation by MAX() function. One optional thing is the use of a where clause to mention the conditions and restrictions that the records of the table should fulfil to consider that record’s column value for fetching the greatest value. The use of the FROM table name clause is required. Where expression can be any name of the column of the table or a formula built up using column names and static literal values or variables, the table_name is the name of the table from which you want to retrieve the records and calculate the greatest value from one of their columns. Hadoop, Data Science, Statistics & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |