Download - Consultas_SQL
Ejecute las siguientes sintaxis y describa cual fue el resultado
Ejecute las siguientes sintaxis y describa cual fue el resultado.
Use educa;
Select *
From curso
Where cred=3 ANd cdept = PHIL;
Select *
From curso
Where (ctarifa > = 100) AND ( ctarifa 2000
UNION
Select distinct fab, producto from pedidos where importe > 3000
LIMIT 0, 25
MySQL ha dicho:
#1146 - Table 'educa.productos' doesn't exist
Select sueldo from personal
UNION ALL
Select fsueldo from claustro;
Error
consulta SQL:
Select sueldo from personal
UNION ALL
Select fsueldo from claustro
LIMIT 0, 25
MySQL ha dicho:
#1146 - Table 'empresa.personal' doesn't existUse educa;
Select cdept, cnombre from curso
Order by cdept, cnombre;
Select cnombre, ctarifa, ctarifa/cred AS TARIFA_POR_CREDITO(ctarifa + 25)/cred AS TARIFA_MEDIA_POR_HORA
From curso where cdept = CIS;
Select * from curso
Where not cdept= CIS OR (ctarifa=0 AND cred=3);
MySQL ha dicho:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ctarifa + 25)/cred AS TARIFA_MEDIA_POR_HORAFrom curso where cdept = "CIS"' at line 2Select ctarifa, SUM(cred) AS CREDITOS_TOTALES From curso
Group By ctarifa
Order By ctarifa DESC;
Select cdept, AVG(ctarifa)
From curso
Group by cdept
HAVING AVG(ctarifa)> 100
AND Count (*) < 6;
MySQL ha dicho:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) < 6LIMIT 0, 25' at line 5