A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • one year ago

Have a quick question on SQL Server

  • This Question is Closed
  1. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  2. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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

  3. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    is there a function or a way*

  4. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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;

  5. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  6. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  7. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

  8. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ok Sweet thank you!

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

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.