Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

MIN

 

The MIN() Function return the Min value of a selected column.
The basic syntax is as follows:
SELECT MIN(Column_Name) FROM Table_Name
Syntax For SQL:
SELECT MIN(Salary) FROM Employee
Employee
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

After Execute: 
MIN(Salary)
25000

No comments:

Post a Comment