Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT*FROM Cliente
- SELECT IDCLIENTE,NCLIENTE FROM Cliente
- SELECT IDCLIENTE AS CODIGO,NCLIENTE AS NOMBRE
- FROM Cliente
- SELECT IDCLIENTE 'CODIGO',NCLIENTE 'NOMBRE'
- FROM Cliente
- SELECT CODIGO = IDCLIENTE,NOMBRE=NCLIENTE
- FROM Cliente
- SELECT C.IDCLIENTE,C.NCLIENTE
- FROM Cliente C
- --ORDENAR ACENDENTE PO RNOMBRE DE CAMPO
- SELECT IDCLIENTE,NCLIENTE
- FROM Cliente
- ORDER BY IDCliente
- -- ORDENAR DECENDENTE
- SELECT IDCLIENTE,NCLIENTE
- FROM Cliente
- ORDER BY 2 DESC
- --ORDENAR ACENDENTE POR ALIAS
- SELECT IDCLIENTE AS 'CODIGO',NCLIENTE
- FROM Cliente
- ORDER BY CODIGO DESC
- --ORDENAR DECENDENTE POR POR NOMBRE Y LUEGO
- --NOMBRES IGUALES ORDENA POR IDCLIENTE
- SELECT IDCLIENTE, NCLIENTE
- FROM Cliente
- ORDER BY 1,2 DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement