Posts

Sql related query

Image
Delete duplicate rows in sql SQL Script to create  Employees  table Create   table  Employees (      ID  int ,      FirstName  nvarchar ( 50 ),      LastName  nvarchar ( 50 ),      Gender  nvarchar ( 50 ),      Salary  int ) GO Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lambeth' ,   'Female' ,  30000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lamb...

Sql Marking question

Image
Delete duplicate rows in sql SQL Script to create  Employees  table Create   table  Employees (      ID  int ,      FirstName  nvarchar ( 50 ),      LastName  nvarchar ( 50 ),      Gender  nvarchar ( 50 ),      Salary  int ) GO Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 1 ,   'Mark' ,   'Hastings' ,   'Male' ,  60000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lambeth' ,   'Female' ,  30000 ) Insert   into  Employees  values  ( 2 ,   'Mary' ,   'Lamb...