Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT clienteNumero, orden, monto FROM pagos
  2. WHERE monto = (SELECT MAX(monto) FROM pagos);
  3.  
  4. clienteNumero orden monto
  5. 6 235 324566
  6.  
  7. WITH Maximo AS(
  8. SELECT clienteNumero, orden, MAX(monto) FROM pagos
  9. )
  10. SELECT * FROM Maximo;
  11.  
  12. clienteNumero orden MAX(monto)
  13. 1 230 324566
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement