Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
breham5343
Starting Member
1 Post |
 Posted - 2014-01-25 : 18:10:38
|
| I am new to programming and I need help with my homework. How do I write a select statement for Write a SELECT statement that returns InvoiceNumber, InvoiceTotal, PaymentTotal and a column Money Owed from the Invoices table that contains the amount currently owed by each Vendor. Results should appear in descending order by the amount of money owed |
|
|
Kristen
Test
22859 Posts |
Posted - 2014-01-25 : 18:27:04
|
| You need to post what you have got so far, and if you are stuck then a question as to what you are stuck on. No point us doing your homework for you - you'll get 100% but not have learnt anything! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-27 : 07:35:59
|
| have a look at GROUP BY and ORDER BY syntax in books online------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Select Statement Help