question

Amit_Mohapatra avatar image
Amit_Mohapatra asked

Query for finding out the result based on conditions.

I have a data set which is displayed above and need to display data based on the following conditions. If Status="Approved" for the element ITtRAINING_1STMAY_3 then do not display row 2 and 3. Similarly, if Status="PendingApproval" for element ITTRAINING_1STMAY_2 then do not display row 6 and 7 and if there are no Approved and pendingApproval status then display all records having Reviewed and PendingReview status.

sql query
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.

Amit_Mohapatra avatar image
Amit_Mohapatra answered

Please help any body..

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.

Jon Crawford avatar image
Jon Crawford answered

Your image does not show for me, do you have any DDL/DML scripted out so that we can recreate test data to do what you want? That will help get you a workable solution

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.

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.