none
count two words in column

    Question

  • 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

Answers

  • 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