Post reply

query

  • June 22, 2010 at 2:55 pm

    #225893

    Hello experts,

    I created the base for a construction firm in MySQL and all the necessary tables. I have a table bid_materials in which there are firm offers and the materials used in the offers.

    How do I create a query that can get all the materials of which the number of repetitions in deals bigger than 5?

    Please help, I'm still beginner 🙂

    Thanks in advance

  • June 22, 2010 at 4:08 pm

    #1183639

    Are you using MySQL or SQL Server?

    If the former, you might be better off using a MySql forum since this is a SQL Server forum. There are "a few differences" between MySql and SQL Server... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply