August 2024
Intermediate to advanced
380 pages
10h 16m
Spanish
Content preview from Aprender SQL, 3ª EdiciónBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Índice
Símbolos
- * (asterisco)
- in Funciones agregadas, Conceptos de agrupación, Cómo se manejan los nulos
- en la cláusula select, La cláusula select
- \(barra invertida), como carácter de escape, Incluidas las comillas simples
- ( ) (paréntesis)
- subconsultas adjuntas, Tablas derivadas (generadas por subconsultas)
- Agrupar operaciones aritméticas, Trabajar con datos numéricos
- agrupar consultas compuestas, Establecer precedencia de operaciones
- Agrupar condiciones de filtro, La cláusula where, Uso de paréntesis
- % (signo de porcentaje), operador de módulo, Realización de funciones aritméticas
- + (signo más), operador de concatenación, SQL Server, Incluyendo caracteres especiales
- (ver también operadores aritméticos)
- ' ' (comillas, simples)
- encerrar cadenas, Generación de cadenas
- secuencia de escape para, Incluyendo comillas simples-Incluyendocomillas simples
- ||(barra vertical, doble), operador de concatenación, Oracle, Incluir caracteres especiales
A
- Función abs(), Manejo de datos con signo
- Función acos(), Realización de funciones aritméticas
- añadir palabras clave de restricción, Creación de restricciones
- añadir palabras clave de índice, Creación de índices
- añadir palabras clave únicas, Índices únicos
- Función add_months(), Funciones temporales que devuelven fechas
- ADO.NET, SQL: Un lenguaje no procedimental
- Funciones de agregación, Conceptos de agrupación-Cómose manejan los nulos, Funciones deinforme-Marcos de ventana
- expresiones en, Uso de expresiones
- filtrado basado en, Conceptosde agrupación-Conceptos de agrupación ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.