Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Unanswered: Microsoft Access basic SQL

    I'm an IT student with very little knowledge on databases. I had some questions about creating an SQL query.

    This practice test is asking me to create an SQL query that will select the fields FundCode and the sum of TotalPledged as FundTotal from the Pledge table and group the data by FundCode. It also specifies not to use brackets around table/field names. How would you write this? Thanks.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    So what have you tried
    to be honest all you need fir the query us already in the text
    use the aggregate function sum to sum the required column, give that sum an alias
    use sn appropriate grouo by term

    There are lots of pages that identify sql syntax and examples on the internet to help
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts