SQL MIN() and MAX() Functions

The SQL MIN() and MAX() Functions

The MIN() function returns the smallest value of the selected column.

The MAX() function returns the largest value of the selected column.
MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

MAX() Syntax

SELECT MAX(column_name)
FROM table_name
WHERE condition;

Comments

Post a Comment

Popular posts from this blog

AWS Lambda – Function in Go

Image
  Go Language support is a recent addition to AWS. To work with Go, you need to select the language from AWS console while creating the AWS Lambda function. In this chapter, let us learn in detail about AWS Lambda function in Go language. Installing Go To get started we need Go Language support. In this section, we will go through following details to start working with AWS Lambda in Go. This is the official site for Go download:  https://golang.org/dl/ Now, download the package as per the operating system. Follow the procedure given here to install Go on the respective operating system. Installation on Windows Observe that for Windows, there is 32-bit and 64-bit download available. Download the zip file and extract the contents and store it in a directory of your choice. Add the environment variables available at  ControlPanel ---> System ---> Advanced system settings. Now, click  Environment Variables  button and add the directory path as shown here − Yo...
Read more

Install DNF in RHEL/CentOS 7

  Install DNF in RHEL/CentOS 7 DNF stands for Dandified yum. DNF is a software package manager for RPM-based Linux distributions such as Fedora, RHEL and CentOS. It is the next upcoming major version of Yum. DNF is first introduced in Fedora and has replaced to become the default package manager of the Fedora distributions. DNF is same as Yum that installs, updates and removes packages on RPM bas4ed Linux systems. DNF is introduced for improving the bottlenecks of Yum such as performance, Memory usages, Dependency resolution, speed, and some other factors. The latest stable release of DNF is 1.0 and it is written in Python.   Installation of DNF in RHEL/CentOS 7 1) To install DNF on RHEL/CentOS 7 systems, you need to set up and enable epel YUM REPO before installing DNF. # yum install epel-release 2) Install DNF # yum install DNF 3) You can now start to run commands using DNF. To view the man page you can use the following command: # dnf –help
Read more

AWS Lambda – Function in Java

Image
Creating JAR file in Eclipse Before proceeding to work on creating a lambda function in AWS, we need AWS toolkit support for Eclipse. For any guidance on installation of the same, you can refer to the  Environment Setup  chapter in this tutorial. Once you are done with installation, follow the steps given here − Step 1 Open Eclipse IDE and create a new project with  AWS Lambda Java Project . Observe the screenshot given below for better understanding − Step 2 Once you select  Next , it will redirect you the screen shown below − Step 3 Now, a default code is created for Input Type  Custom . Once you click  Finish  button the project gets created as shown below − Step 4 Now, right click your project and export it. Select  Java / JAR  file from the  Export  wizard and click  Next . Step 5 Now, if you click  Next , you will be prompted save the file in the destination folder which will be asked when you click on next. Once the...
Read more