Saturday, 10 February 2018

SQL Min() & Max() functions


SQL MAX functions:- It will return largest value of the selected column.

Query :-  select MAX(columnname) as ID  from tablename

SQL MIN functions:- It will return smallest value of the selected column.

Query :-  select MIN(columnname) as ID  from tablename


No comments:

Post a Comment