Database

Aptiva Dave wrote:

select appID from applicant where Year(entryDate) < Year(getDate())

select datediff(year,entryDate,getdate()) 

Tripathi Swati wrote:

put trigger on your applicant table which will fire after insert

declare @t table(name varchar(50),subject varchar(50))
insert into @t 
	select 'sri','physics' union all 
	select 'sri','chemistry' union all
	select 'sri','maths' union all
	select 'amit','physics' union all 
	select 'amit','bio' union all
	select 'amit','maths' union all
	select 'sanjay','physics' union all 
	select 'sanjay','chemistry' union all
	select 'sanjay','maths' union all
	select 'Ritu','physics' union all 
	select 'Ritu','chemistry' union all
	select 'Ritu','bio'

select name from @t 
where subject ='maths' or subject ='physics' or subject ='chemistry'
group by name
having (COUNT(name)>2)

name

sanjay
sri

Declare
  @Var VARCHAR(100)
 
  
SET @Var = 'QWERTYUIOP'

--Replace(@Var, 'Q', 'X') Use this to replace @Var when nesting

SELECT Replace(Replace(Replace(@Var, 'Y', '_'), 'P', 'X'), 'Q', 'X')