query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » query

query

Rate Topic

Display Mode

Topic Options

Author

Message

amra-ze

Posted Tuesday, June 22, 2010 2:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 22, 2010 2:49 PM
Points: 1, Visits: 0

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

Post #941361

LutzM

Posted Tuesday, June 22, 2010 4:08 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

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... Wink

Lutz
A pessimist is an optimist with experience.

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

Post #941401

« Prev Topic | Next Topic »

Permissions