SQL clause: newbie question

Question

I have this table:

culture   street
------------------------
es        Calle Roma 15
eu        Via Roma 15
es        Calle Paris 20
eu        Via Paris 20

Is possible to create an SQL query that retrieve first the rows that the value "es" (in the field culture of course) and the rows that the value "es"?

Answer 1

There are many different ways to achieve this. One of it is to use UNION:

select * from tbl where culture = 'es'
UNION
select * from tbl where culture = 'eu'

Answer 2

If your table only contains es and eu cultures you can just do an order by

select * from tbl
order by culture

Answer 3

select * from tbl where culture = 'es' or culture = 'eu'
order by culture

should also do the trick :)