Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT APELLIDOS FROM CAMIONEROS WHERE APELLIDOS LIKE '%O%';
- SELECT ID_CAMIONES,placa,tipo,modelo FROM CAMIONES WHERE ID_CAMIONES BETWEEN 75589 AND 75591;
- select NOMBRE from CAMIONEROS where exists(select nombre from CAMIONEROS where nombre = 'Joe');
- SELECT * FROM CAMIONEROS a where not exists(select nombre from CAMIONEROS b where a.ID_CAMIONEROS = b.ID_CAMIONES and NOMBRE =
- SELECT * from camioneros
- WHERE (ID_CAMIONERO > 6000) AND (direccion = 'Santiago');
- SELECT * from camioneros
- WHERE (ID_CAMIONERO > 6000) AND (direccion = 'La Vega' or nombre='M');
- SELECT * from camioneros
- WHERE (apellidos like '%D%' and direccion ='La Vega') or (nombre ='J' and telefono like '809');
- SELECT * FROM CAMIONEROS
- WHERE TELEFONO like '829%' AND TELEFONO LIKE '%8';
- SELECT * FROM CAMIONEROS
- WHERE DIRECCION IN('La Vega', 'Santiago');
- SELECT * FROM CAMIONEROS
- WHERE ID_CAMIONERO BETWEEN 6595 AND 6600 AND TELEFONO LIKE '%8%';
- SELECT NOMBRE, COUNT(ID_CAMIONERO)
- FROM CAMIONEROS
- ---EJEMPLO DE SELECT--
- SELECT C.NOMBRE, COUNT(ID_PAQUETE)
- FROM CAMION C, TRANSPORTE T, TRANSPORTE_PAQUETE TP
- WHERE C.ID_CAMION= I.ID_CAMION
- AND I.ID_TRANSPORTE= TP.ID_TRANSPORTE
- GROUP BY C.NOMBRE
- ORDER BY COUNT(ID_PAQUETE) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement