Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Filter Query in SQL
basit khan
Nov 1 2016 11:07 AM
247
Reply
Hi,
I have a table Employee
Emp_No int
Emp_Name nvarchar(50)
Emp_DeptNo nvarchar(150)
Emp_No
Emp_Name
Emp_DeptNo
1
A
1, 2 , 3, 5
2
B
2
3
C
4, 5
Here i want to filter by Emp_DeptNo Where Emp_DeptNo in (3, 5) then result will be
Emp_No
Emp_Name
Emp_DeptNo
1
A
1, 2 , 3, 5
3
C
4, 5
How to filter this
Thanks
Basit.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
insert only column name into another table
Get data from multiple databases into single store procedure