maximo07 Posted April 23, 2014 Report Share Posted April 23, 2014 HOLA TENGO ESTE CODIGO Y ME TIRA UNA LISTA LARGA CON REGISTRO NECESITO QUE SOLO ME MUESTRE EL PRIMERO QUE ES EL QUE NECESITO DEJO EL CODIGO TABLAS,CAMPEONATO,PARTIDOS Select distinct c.nombre as campeonato, j.id_club_ganado,c.campeonfrom campeonato c, partidos j,campeonato cm where j.id_club_ganado=j.id_club_ganadoand j.id_club_ganado=j.id_club_ganado EN SQL SERVER ME FUNCIONA CON EL COMANDO TOP 1 PERO EN POSTGRE NO SIRVE Link to comment Share on other sites More sharing options...
Ra Posted April 23, 2014 Report Share Posted April 23, 2014 En PostgreSQL (y MySQL también) existe LIMIT para eso... Al final de tu consulta tienes que poner LIMIT 1 Salu2. Link to comment Share on other sites More sharing options...
maximo07 Posted April 23, 2014 Author Report Share Posted April 23, 2014 graciasss masterrr ;) Link to comment Share on other sites More sharing options...
cañangasñangas Posted April 23, 2014 Report Share Posted April 23, 2014 graciasss masterrr ;) lo damos por solucionado entonces? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now