count two words in column


  • i want to count two words like java and sql in one column and words either one word occurance in row it also count.

    Manish Khare

    Monday, April 29, 2013 3:41 PM


  • What is your current query? You may add to your query

    select ..., count(case when Resume like N'%sql%' then 1 else 0 end) over () as CountSQL, count(case when Resume like N'%java%' then 1 else 0 end) over() as CountJava from myTable where ...

    For every expert, there is an equal and opposite expert. - Becker's Law

    My blog

    Monday, April 29, 2013 5:01 PM

All replies