How to retrive these type of data using sqlserver

Question

0.00/5 (No votes)

See more:

I have table like:

sno	student	courses
1	raj	C#,c
2	sur	java,strins
3	muni	C#,asp.net
4	rani	C#,java script

I want how to retrive persons who knows C# can you guide or send any snippets
how to write stored procedure

To get people who who knows C# and strins

Posted 21-Nov-12 20:21pm

kingsa

Updated 21-Nov-12 21:41pm

markovl

v5

Add a Solution

Comments

MT_ 22-Nov-12 6:17am

did you solve the issue? solution below helped?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MT_ · Answer 1 · 2012-11-21T20:33:00

Solution 1

This query should work for you

SQL

Select student from tableName where
courses like 'C#%'

Hope that helps. If it does, mark it as answer/upvote.
Milind

Posted 21-Nov-12 20:33pm

MT_

How to retrive these type of data using sqlserver

1 solution

Solution 1

Add your solution here

Preview 0

How to retrive these type of data using sqlserver

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us