Is it possible to LIMIT more than one output? 1

[basildon]

I have a Business database with many countrys on.

If I want to extract any 200 companies in Germany (in the same table) I could use

SELECT * FROM table
WHERE (country LIKE 'GER%')
LIMIT 200 ;

If, however, I want to select 200 companies from Germany, 200 from Spain, and 200 from Italy, can this be done in a single query?

Thanks

 

[sleipnir214]

Unfortunately, no. The LIMIT directive operates at the level of the entire query, not at the level of the WHERE directive.

You could insert into a HASH table the first 200 of each company in three separate queries, then select all from that new table.

Or another way to do it would be to change your table structure by adding a column which numbers each company within a country. (The first German company entered into the table would get a count of 1, the first Italian company also a 1, the second German company would get at 2, etc). Then you could use a WHERE clause like WHERE ((country like 'GER%' or country like 'ITA%' or country like 'SPA%') and count < 200).