Question

Have a quick question on SQL Server

Answer 1

I have done some SQL Server. Alot more on larger DB's like Netezza, Oracle. Whats your question ?

Answer 2

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

Answer 3

is there a function or a way*

Answer 4

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;

Answer 5

we aren't using any database functions yet just some math functions and criteria to limit the rows from the table

Answer 6

oh ok so SQL does have some math functions you can use though right?

Answer 7

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.

Answer 8

Ok Sweet thank you!