Perdon, falto el desc *Select top 1 * from producto_maquina order by valor desc*
El 23 de mayo de 2011 12:52, Daniel Calvin <[email protected]>escribió: > Select top 1 * from producto_maquina order by valor > > El 23 de mayo de 2011 12:46, Miguel Canchas <[email protected]>escribió: > >> Producto valor maquina >> >> AFX017000 39.50 P00090 >> >> AFX017000 34.50 P00100 >> >> AFX017000 38.00 S06000 >> >> AFX017000 37.00 S08000 >> >> AFX017000 37.23 S17000 >> >> AFX017000 37.00 S24000 >> >> AFX017000 43.14 S26000 >> >> AFX017000 37.00 S27000 >> >> >> >> select producto, MAX(valor), maquina from producto_maquina group byproducto, >> maquina >> >> >> >> >> >> como podria hacer para que solo me aparezca asi : >> >> >> >> AFX017000 43.14 S26000 >> >> >> >> O sea solo el que tiene mayor valor. >> >> >> >> Por favor una mano.. >> >> >> >> Gracias >> >> >> >> MK >> >> >> >> >> > > > > -- > *Daniel A. Calvin* > Cooperator Team Member > Microsoft Certified Professional > -- *Daniel A. Calvin* Cooperator Team Member Microsoft Certified Professional
