Results 1 to 5 of 5

Thread: MsSql

  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Exclamation Unanswered: MsSql

    hello sir,
    I'm new database i need help here i have a database scheme....

    PERSON( driver_id:string , name:string , address:string )
    CAR( regno:string , model:string , year:int )
    ACCIDENT( report_number:int , accd_date:date , location:string )
    OWNS( driver_id:string , regno:string )
    PARTICIPATED( driver_id:string , regno:string , report_number:int , damage_amount:int)

    Now i Need Query for the following Issue

    1)Find the name of owner who owns a car that has minimum damage amount for accidents in 2008
    2)Find the people who owned cars that were involved in accidents at every location.
    3)Find the locations at which minimum and maximum number of accidents occur
    4)For each owner who owns more than two cars, list the ownerid, regno of the car having maximum damage amount, and number of accidents.

    Plz Help me Thank You.....

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so
    you need an appropriate WHERE clause for each question
    you need to form an adequate JOIN for each question
    you need to make appropriate use of SQL functions such as MIN, COUNTand MAX

    however this section is for the MONGO DB, in the NoSQL section, which really isn't going to help you get an answer. as you title this 'MsSQL' do you want the question moving there?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Please post in the appropriate forum section to get help for your issue.

  4. #4
    Join Date
    Aug 2013
    Posts
    3

    Please can you take a look and reestablish the import for the order_item table

    We have an automated import tool that automaticllay imports data from the IMS MySQL data base to Zoho reports. One of the tables has not updated since the 18th of July (this is odd as there have been no changes to the table and other tables have updated correctly).We did manually import a record without any data configuration changes and it imported successfully.
    Please can you take a look and reestablish the import for the order_item table

  5. #5
    Join Date
    Aug 2013
    Posts
    2
    Will this be working properly in oracle database 12c, cause i read in a Oracle Connections forums??

Posting Permissions

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