SELECT query for SQL server

Question

1.00/5 (1 vote)

See more:

Hi All,
I need to write a SQL Query for the below --
I have a scenario where Students enrolled for English, Mathematics.
Now if the student Enrollment number is already in English group then it should not come to Mathematics group.

Thanks to All.

What I have tried:

I am able to Group By but the same student Enrollment number is coming in Both the group. But my requirement is If in one group it is added then another group it should not come.
I tried by my Self and also check in Google.

Posted 13-Aug-19 22:51pm

IndrajitDasgupat

Updated 20-Aug-19 2:13am

Add a Solution

Comments

MadMyche 14-Aug-19 6:27am

So, let's see the query(ies) that didn't work, and also show us what you expect as a result.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2019-08-13T23:12:00

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

Maciej Los · Answer 2 · 2019-08-14T00:33:00

All what you have to do is to count the number of occurrences for that student. For example:

SQL

SELECT COALESCE(SUM(CASE WHEN StudentID=@stuid THEN 1 ELSE 0 END), 0) AS NoOfOccurr
FROM TableWhereStudentIsAssignedToGroup

Note: you did not provide a structure of database or sample data, so above query is just an example.

There's few other ways to achieve that, but knowing nothing about a database, i can't help.

Aarti Meswania · Answer 3 · 2019-08-20T02:13:00

Hi,

Have you tried Except?

SQL

;with tbl as
(
	select 1 as enrollNo, 'English' as grp union
	select 1 as enrollNo, 'Maths' as grp union
	select 2 as enrollNo, 'English' as grp union
	select 3 as enrollNo, 'English' as grp union
	select 4 as enrollNo, 'Maths' as grp 
)
select enrollNo from tbl where grp = 'English'
except 
select enrollNo from tbl where grp = 'Maths'
------------------------------Output------------------------------
/*
enrollNo
-----------
2
3
*/

You can learn more useful commands like Intersect, except, union etc.

Happy Coding! :)

SELECT query for SQL server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0