Consultas bases de datos oracle Bases de Datos Avanzadas, Consultas básicas

1

SELECT *

FROM libro;

2

SELECT autor, titulo

FROM libro;

3

SELECT DISTINCT autor

FROM libro;

1

SELECT *

FROM libro

WHERE autor = 'Sagan Carl'

2

SELECT *

FROM libro

WHERE autor = 'sagan Carl'

3

SELECT *

FROM libro

WHERE precio > 300

4

SELECT *

FROM libro

WHERE precio BETWEEN 300 AND 500

5

SELECT *

FROM libro

WHERE precio IN(412,388)

6

SELECT *

FROM libro

WHERE autor LIKE 'S%'

7

SELECT *

FROM libro

WHERE autor LIKE '_a%'

8

SELECT *

FROM libro

WHERE autor NOT LIKE 'S%'

9

SELECT *

FROM libro

WHERE titulo IS NULL

10

SELECT *

FROM libro

WHERE precio > 500

AND editorial = 'Mc Graw Hill'

11

SELECT *

FROM libro

WHERE precio > 500

AND editorial = 'Mc Graw Hill'

OR editorial = 'Pearson'

12

SELECT *

FROM libro

WHERE precio > 500

AND (editorial = 'Mc Graw Hill'

OR editorial = 'Pearson')

13

SELECT *

FROM libro

WHERE precio > 500

OR editorial = 'Pearson'

14

SELECT *

FROM libro

WHERE NOT precio > 500

1

SELECT *

FROM libro

ORDER BY precio

2

SELECT *

FROM libro

ORDER BY precio DESC

3

SELECT *

FROM libro

ORDER BY 5 DESC

4

SELECT autor "A", titulo "T", editorial "E"

FROM libro

ORDER BY "A"

5

SELECT DISTINCT editorial

FROM libro

ORDER BY editorial

6

SELECT DISTINCT editorial

FROM libro

ORDER BY editorial NULLS FIRST

1

SELECT COUNT(*)

FROM libro

2

SELECT COUNT (titulo), COUNT (editorial)

FROM libro

3

SELECT SUM(precio)

FROM libro

4

SELECT AVG(precio)

FROM libro

5

SELECT NVL(precio,0)

FROM libro

6

SELECT AVG(precio), AVG(NVL(precio,0))

FROM libro

7

SELECT MIN(precio), MAX(precio)

FROM libro

8

SELECT MIN(precio) AS "Precio Minimo", MAX(precio) AS "Precio Maximo"

FROM libro

9

SELECT AVG(CASE WHEN editorial = 'Planeta' THEN precio*1.5

                WHEN editorial = 'Critica' THEN precio*2.0

                ELSE precio

            END) AS AVG

FROM libro