Syntax:-
Select Max (col1) from table_name
In this article, we are going to use the following table for the examples:-
CREATE TABLE [dbo]. [Employee](
[Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,
[EmpNumber] [nvarchar](50) NOT NULL,
[EmpFirstName] [nvarchar](150) NOT NULL,
[EmpLAStName] [nvarchar](150) NULL,
[EmpEmail] [nvarchar](150) NULL,
[Salary] [int] NULL
)
We insert following data into the above tables:-
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A001′,’Vivek’,’Johari’,’samir@abcmail.com’,200000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A002′,’Abhinav’,’Golwalkar’,’abhinav@abcmail.com’,100000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A003′,’Neha’,’Sharma’,’neha@abcmail.com’,300000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A004′,’Chandra’,’Singh’,’vivek@abcmail.com’,320000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A005′,’Avinash’, ‘Dubey’,’avinash@abcmail.com’,250000)
For example, query to get the maximum salary of an employee from the table Employee is given below:-
Select Max (salary) from Employee
It will gives the following result:-
320000
Pingback: apex legends season 2 trailer,
Pingback: 카지노사이트
Pingback: bong88
Pingback: อยาก รี ไฟแนนซ์ บ้าน
Pingback: https://internetnews.net.pl/forum/nowe-technologie-f7/poznam-opinie-o-funkymedia-t62.html
Pingback: Website
Pingback: https://www.olx.pl/
Pingback: Nachfolger
Pingback: Tochka Market
Pingback: Agartha Market Exit Scam
Pingback: Drogen kaufen
Pingback: financial analysis industry
Pingback: Darknet
Pingback: Elastomer Stoppers Market Regional Data Analysis 2019-2027
Pingback: สินเชื่อขอนแก่น
Pingback: baccarat truc tuyen
Pingback: ซีเกมส์ 2019
Pingback: new santali 2013
Pingback: qiuqiu99
Pingback: เวดดิ้ง
Pingback: Togel OnLine
Pingback: khong vao duoc 12bet
Pingback: manele noi 2020
Pingback: chơi xổ số trực tuyến
Pingback: poker 99
Pingback: marketing for dummies