4. Using a set operator, display the creditor number of all creditors who have

4. Using a set operator, display the creditor number of all
creditors who have ever been paid.

Question Posted / balu_deepak10

2 Answers
3976 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

4. Using a set operator, display the creditor number of all creditors who have ever been paid...

Answer / srinivas

select credit_number from table where paid <> 1

[NOTE: Here we can use boolean value to paid field, if paid is success 1 inserted and if not paid then insert 0].

From above query , there is displays credit numbers with never paid.

Is This Answer Correct ?

0 Yes

0 No

4. Using a set operator, display the creditor number of all creditors who have ever been paid...

Answer / anil

select * from TN where bal is not null;
intersect
select * from TN where bal is null;

Is This Answer Correct ?

2 Yes

6 No

Post New Answer