anonymous
  • anonymous
Have a quick question on SQL Server
Computer Science
chestercat
  • chestercat
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
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.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this
and thousands of other questions

anonymous
  • anonymous
I have done some SQL Server. Alot more on larger DB's like Netezza, Oracle. Whats your question ?
anonymous
  • anonymous
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
anonymous
  • anonymous
is there a function or a way*

Looking for something else?

Not the answer you are looking for? Search for more explanations.

More answers

anonymous
  • anonymous
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;
anonymous
  • anonymous
we aren't using any database functions yet just some math functions and criteria to limit the rows from the table
anonymous
  • anonymous
oh ok so SQL does have some math functions you can use though right?
anonymous
  • anonymous
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.
anonymous
  • anonymous
Ok Sweet thank you!

Looking for something else?

Not the answer you are looking for? Search for more explanations.