question

ramana avatar image
ramana asked

Count as a computed column

I need two columns from a table & I need one computed column of count() Ex: Employee table Emmployeeid LastName 1 Level 2 Target 3 David This is the table. I need the result 3 columns. These 2 columns & third computed column consists of no. of e. Answer should be like below Ans:Employeeid Lastname countof'e' 1 Level 2 2 Target 1 3 David 0 How can I write T-SQL query for this. Thanks.
countcomputed-columnstring-function
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.