At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.
Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
I have done some SQL Server. Alot more on larger DB's like Netezza, Oracle. Whats your question ?
Alright Lets see how to word this. I am very new to SQL server but I have created a table that holds a customers Credit Limit and there balance. Is there a function way for me to show how much the customer is over their credit limit
Not the answer you are looking for? Search for more explanations.
more of a way using SQL of course. So lets say the table is customer ( credit_limit int, balance int, customer_name varchar(50)). I would say select customer_name, balance-credit_limit as over_amount from customer where balance > credit_limit;
we aren't using any database functions yet just some math functions and criteria to limit the rows from the table
oh ok so SQL does have some math functions you can use though right?
all databases have math functions. I use Netezza as a DBA and there are functions that are included. Sql Server has math functions as well. Most of the functions that DB's have are defined in the ANSI SQL standards. Most databases comply with those standards and make them accessible.