Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Symbol Exchange Date Year
- FLWS NAS 2013-05-01 2015
- FLWS NAS 2013-05-01 2014
- FLWS NAS 2013-05-01 2013
- FCCY NAS 2013-05-01 2014
- FCCY NAS 2013-05-01 2013
- SRCE NAS 2013-05-01 2014
- SRCE NAS 2013-05-01 2013
- SRCE NAS 2013-05-01 2012
- FNHC NAS 2013-05-01 2014
- FNHC NAS 2013-05-01 2013
- DDD NYS 2013-05-01 2015
- DDD NYS 2013-05-01 2014
- DDD NYS 2013-05-01 2013
- DDD NYS 2013-05-01 2012
- MMM NYS 2013-05-01 2015
- MMM NYS 2013-05-01 2014
- MMM NYS 2013-05-01 2013
- MMM NYS 2013-05-01 2012
- JOBS NAS 2013-05-01 2014
- JOBS NAS 2013-05-01 2013
- Declare @Table table (Symbol varchar(25),Exchange varchar(25),Date Date,Year int)
- Insert Into @Table (Symbol,Exchange,Date,Year) values
- ('FLWS','NAS','2013-05-01',2015),
- ('FLWS','NAS','2013-05-01',2014),
- ('FLWS','NAS','2013-05-01',2013),
- ('FCCY','NAS','2013-05-01',2014),
- ('FCCY','NAS','2013-05-01',2013),
- ('SRCE','NAS','2013-05-01',2014),
- ('SRCE','NAS','2013-05-01',2013),
- ('SRCE','NAS','2013-05-01',2012),
- ('FNHC','NAS','2013-05-01',2014),
- ('FNHC','NAS','2013-05-01',2013),
- ('DDD','NYS','2013-05-01',2015),
- ('DDD','NYS','2013-05-01',2014),
- ('DDD','NYS','2013-05-01',2013),
- ('DDD','NYS','2013-05-01',2012),
- ('MMM','NYS','2013-05-01',2015),
- ('MMM','NYS','2013-05-01',2014),
- ('MMM','NYS','2013-05-01',2013),
- ('MMM','NYS','2013-05-01',2012),
- ('JOBS','NAS','2013-05-01',2014),
- ('JOBS','NAS','2013-05-01',2013)
- Select A.*
- From @Table A
- Join (Select Symbol,Hits=count(Distinct Year),MinYear=min(Year) From @Table Group By Symbol) B on (A.Symbol=B.Symbol and B.Hits=3 and B.MinYear=2013)
- Order By Symbol,Year
- Symbol Exchange Date Year
- FLWS NAS 2013-05-01 2013
- FLWS NAS 2013-05-01 2014
- FLWS NAS 2013-05-01 2015
- select * from table
- where symbol in ( select Symbol from table
- where year in (2013, 2014, 2015)
- group by symbol
- having count (distinct year) = 3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement