ATOTCLIC Linux Top sqlserver, Limit Mysql y Rownum Oracle

Top sqlserver, Limit Mysql y Rownum Oracle

16 octubre, 201616 octubre, 2016| atotclicatotclic| 0 comentarios | 22:43
Categorías:

select top 10 * from employees ;

select * from employees limit 10

select * from employees WHERE ROWNUM <=5;

 

Related Post

Mysql consultasMysql consultas

SELECT table_name AS "Tables", round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC; SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',

Leer másLeer más