0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

create table #CheckTest(
    name varchar(50)
)


select count(c1.name), count(*)  from #CheckTest c
left join #CheckTest c1 on c.name = c1.name and c1.name = 'test'


drop table #CheckTest

fork query

edited feb 7 12

created feb 7 12 anonymous