Posts Tagged: mimimum salary by department wise

Maximum and minimum salary department wise in Sql server

Let’s first create a table having four fields. CREATE TABLE table1( [id] [int] NULL, [Name] [varchar](30) NULL, [Salary] [int] NULL, [DepId] [int] NULL ) Now insert some record in this table. INSERT table1 VALUES (1, ‘test1’, 1200, 1) INSERT table1… Continue Reading →