473,387 Members | 1,597 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Find Unequal Types by Comparison

Column A has transaction ID that is the same for all Debits and Credits, as identified in another column. I need to see where all Debits equal all Credits for all rows where Column A are the same. So, column A identifies the transaction. Column B has a D or a C. Column C has an amount. I need to find where the debits do not equal the credits for items with the same transaction ID.
Jul 5 '15 #1
3 1697
computerfox
276 100+
What's the query that you built so far?
Jul 6 '15 #2
RonB
589 Expert Mod 512MB
I need to see where all Debits equal all Credits for all rows where Column A are the same.
I need to find where the debits do not equal the credits for items with the same transaction ID
Answer based on what you asked, not on what you need.
Expand|Select|Wrap|Line Numbers
  1. select * from table;
Please clarify your question.
Jul 6 '15 #3
ck9663
2,878 Expert 2GB
I got lost somewhere. It would be great if you post some sample data and explain it from there.


~~ CK
Jul 7 '15 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: rickle | last post by:
I'm trying to compare sun patch levels on a server to those of what sun is recommending. For those that aren't familiar with sun patch numbering here is a quick run down. A patch number shows...
4
by: Matthias Hildebrand | last post by:
Hello, std::map< int, MyClass*> mymap; it = mymap.find( somekey ) // here happen bad things if( it != mymap.end() ) { // do something useful with it->second } else
4
by: Tom | last post by:
Hi, I need some help with stl maps. I am using a std::map that is sorted in a very special way. Therefore I am using my own sort function. That works fine. But this is only half the problem....
6
by: Tom Kelleher | last post by:
Folks, I have a client who will likely be looking at ASP.NET in the near future. They have an internal developer who is convinced there are "scalability problems" with ASP.NET. This client has...
1
by: Tim Mulholland | last post by:
I am setting up all my settings using the built-in settings stuff in Visual Studio (though using my own provider to change the storage location/type for the settings). All goes well until i try...
37
by: spam.noam | last post by:
Hello, Guido has decided, in python-dev, that in Py3K the id-based order comparisons will be dropped. This means that, for example, "{} < " will raise a TypeError instead of the current...
32
by: Panks | last post by:
Hey All Its one of basic questions? i read in a book "Thinking in C++" it says " Overloading solely on return value is a bit too subtle, and thus isn't allowed in C++." on page 323. While i...
2
by: jehugaleahsa | last post by:
Hello: I find myself writing Comparison<Tdelegates that looks like this: private static int compareCustomers(Customer lhs, Customer rhs) { int result =...
5
by: * Tong * | last post by:
Hi, Simple questions, How to find where types are defined? And, how can I find which paths are considered standard by my g++? I get, error: 'off_t' does not name a type I know that if I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.