Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT clienteNumero, orden, monto FROM pagos
- WHERE monto = (SELECT MAX(monto) FROM pagos);
- clienteNumero orden monto
- 6 235 324566
- WITH Maximo AS(
- SELECT clienteNumero, orden, MAX(monto) FROM pagos
- )
- SELECT * FROM Maximo;
- clienteNumero orden MAX(monto)
- 1 230 324566
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement