Interested to Buy Any Domain ? << Click Here >> for more details...
4. Using a set operator, display the creditor number of all
creditors who have ever been paid.
- 2 Answers
- 5144 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
How can we delete duplicate rows in a table?
What are the advantages of oracle?
How to generate query output in html format?
How you find out version of installed workflow?
What is a recycle bin in oracle?
What are the types of Database Links ?
What are the different type of Segments ?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
Is truncate autocommit in oracle?
How to create a server parameter file?
Oracle General 
