Azure SQL Database
An Azure relational database service.
5,581 questions
Hi, @Juneja, Namita I tried the below query please check if this is what you are looking for.
Regrds
Geetha
SQL, Print id having different type combination and different status
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 41%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Juneja, Namita
1
Reputation point
Hello everyone,
So my data looks like this
I want to print Id 4 which has combination of type as (EM +RC/CC) and all of them have different status
Please help
Thanks
{count} votes
-
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee2022-02-14T21:46:51.737+00:00 Hi, @Juneja, Namita Welcome to Microsoft Q&A, thanks for posting your question.
Can you please let us know what the query result looks like?Regards
Geetha
Sign in to comment
1 answer
Sort by: Most helpful
-
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee
2022-02-15T01:59:25.35+00:00 -
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee
2022-02-15T20:24:09.527+00:00 Hi @Juneja, Namita Did you have the chance to check the above reply, Please let us know if you are still facing the same issue?
Regards
Geetha -
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee
2022-02-16T22:39:01.293+00:00 Hi, @Juneja, Namita Did you have the chance to check the above reply, Please let us know if you are still facing the same issue?
Regards
Geetha
Sign in to comment -