First Database In Sql Server

IIF statement

Case statement in Sql server

Delete rows with subquery

create table #test(id int,name varchar(200))

insert into #test
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union  all
select 1,'Shabash '
union all
select 1,'Shrikant'
union  all
select 1,'Shrikant'


alter table #test
add Row_id int identity(1,1)

--with subquery
delete a from #test a
where a.Row_id not in ( select  min (Row_id) from #test group by Id,name)

select * from #test

Sargable vs Non Sargable Query in SQL server - Part 2

Sargable vs Non Sargable Query in SQL server

Sargable vs Non Sargable Query in SQL server

Cross apply and outer apply in sql server

https://www.youtube.com/channel/UCbnr0iY4hTybmipXGNwsdhQ?sub_confirmation=1

Differences between ISNULL and NULLIF

Ways to replace NULL in sql server

Merge in SQL Server - Part 2