Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


SQL Query (displaying fields)

harpharp Member Posts: 3
I need to display what a customers total purchases (Purchases) were on a specific product and what their total purchases (Total Purchased) were overall. These two columns come from the same table and should be displyed in the same query result.

This is to view what percentage of money is spent on a particular product as opposed to other products.

If possible just provide me with the syntax and I can fill in the appropriate fields.



  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    _________ | | free ebooks and video tutorials about | MATLAB, C++, Delphi, PHP, Go, Assembly, Python, Ruby, Visual Basic .NET, C#, Perl, JavaScript, C, R, Java, PL/SQL, Scratch, Visual Basic, Swift, Objective-C Crystal, Transact-SQL, Clojure, Scheme, Apex, Lua, Julia, Ada, Fortran, ML, FoxPro, VBScript, Hack, F#, LabVIEW, ABAP, Lisp, D, Logo, Alice, Rust, Dart, Kotlin, Awk, Prolog, Bash, SAS, Erlang, Scala, COBOL | ______

Sign In or Register to comment.