2024-03-29T11:44:06Zhttps://repositori.uji.es/oai/requestoai:repositori.uji.es:10234/1687482021-09-16T09:07:21Zcom_10234_168735com_10234_168002com_10234_119723com_10234_7col_10234_168737
Repositori UJI
author
Marqués-Andrés, Mercedes
other
Universitat Jaume I. Departament d'Enginyeria i Ciència dels Computadors
2017-09-14T12:12:00Z
2017-09-14T12:12:00Z
2014
http://hdl.handle.net/10234/168748
En este vídeo vemos el uso de las subconsultas, que son sentencias SELECT anidadas en otra sentencia SQL.
spa
Atribución-NoComercial-CompartirIgual 4.0 Internacional
bases de datos
informática
modelo relacional
SQL
Databases
Computer Science
relational database systems
Vídeo 6: Consultas en SQL: subconsultas
Video
TElDRU5DSUEgREUgRElTVFJJQlVDScOTTiBOTyBFWENMVVNJVkEKCkFjZXB0YW5kbyBlc3RhIGxpY2VuY2lhLCB1c3RlZCAoZWwgYXV0b3IvZXMgbyBlbCBwcm9waWV0YXJpby9zIGRlIGxvcyBkZXJlY2hvcyBkZSBhdXRvcikKZ2FyYW50aXphIGEgbGEgVW5pdmVyc2l0YXQgSmF1bWUgSSBlbCBkZXJlY2hvIG5vIGV4Y2x1c2l2byBkZSBhcmNoaXZhcgplbiBlbCBSZXBvc2l0b3JpbyBVSkksIHJlcHJvZHVjaXIgKGNvbW8gc2UgZGVmaW5lIG3DoXMgYWJham8pLApjb211bmljYXIgeS9vIGRpc3RyaWJ1aXIgc3UgZG9jdW1lbnRvIG11bmRpYWxtZW50ZSBlbiBmb3JtYXRvIGVsZWN0csOzbmljby4KClRhbWJpw6luIGVzdMOhIGRlIGFjdWVyZG8gY29uIHF1ZSBsYSBVbml2ZXJzaXRhdCBKYXVtZSBJIHB1ZWRhIGNvbnNlcnZhciAKbcOhcyBkZSB1bmEgY29waWEgZGUgZXN0ZSBkb2N1bWVudG8sIHksIHNpbiBhbHRlcmFyIHN1IGNvbnRlbmlkbywKdHJhbnNmb3JtYXJsbyBhIG90cm9zIGZvcm1hdG9zLCBhcG95b3MgbyBtZWRpb3MgcGFyYSBnYXJhbnRpemFyCmxhIHNlZ3VyaWRhZCwgcHJlc2VydmFjacOzbiB5IGFjY2Vzby4KCkRlY2xhcmEgcXVlIGVsIGRvY3VtZW50byBlcyB1biB0cmFiYWpvIG9yaWdpbmFsIHN1eW8geS9vIHRpZW5lIGVsIGRlcmVjaG8KcGFyYSBvdG9yZ2FyIGxvcyBkZXJlY2hvcyBjb250ZW5pZG9zIGVuIGVzdGEgbGljZW5jaWEuClRhbWJpw6luIGRlY2xhcmEgcXVlIHN1IGRvY3VtZW50byBubyBpbmZyaW5nZSBsb3MgZGVyZWNob3MKZGUgYXV0b3IgZGUgb3RyYSBwZXJzb25hIG8gZW50aWRhZC4KClNpIGVsIGRvY3VtZW50byBjb250aWVuZSBtYXRlcmlhbGVzIGRlIGxvcyBjdWFsZXMgbm8gdGllbmUgZGVyZWNob3MgZGUgYXV0b3IsCmRlY2xhcmEgcXVlIGhhIG9idGVuaWRvIGVsIHBlcm1pc28gbmVjZXNhcmlvIHBhcmEgb3RvcmdhciBhIGxhIFVuaXZlcnNpdGF0IEphdW1lIEkKbG9zIGRlcmVjaG9zIHJlcXVlcmlkb3MgcG9yIGxhIHByZXNlbnRlIGxpY2VuY2lhLCB5IHF1ZSBlbCBtYXRlcmlhbCBjb24gZGVyZWNob3MKZGUgdGVyY2Vyb3MgZXN0w6EgY2xhcmFtZW50ZSBpZGVudGlmaWNhZG8geSByZWNvbm9jaWRvIGVuIGVsIGNvbnRlbmlkbwpkZWwgZG9jdW1lbnRvIGVudHJlZ2Fkby4KClNpIGVsIGRvY3VtZW50byBzZSBiYXNhIGVuIHVuYSBvYnJhIHF1ZSBoYSBzaWRvIHBhdHJvY2luYWRhIG8gYXBveWFkYQpwb3IgdW5hIG9yZ2FuaXphY2nDs24gZGlmZXJlbnRlIGVuIGxhIFVuaXZlcnNpdGF0IEphdW1lIEksIApzZSBwcmVzdXBvbmUgcXVlIHNlIGhhIGN1bXBsaWRvIGNvbiBjdWFscXVpZXIgZGVyZWNobyBkZSByZXZpc2nDs24KdSBvdHJhcyBvYmxpZ2FjaW9uZXMgcmVxdWVyaWRhcyBwb3IgZXN0ZSBjb250cmF0byBvIGFjdWVyZG8uCgpMYSBVbml2ZXJzaXRhdCBKYXVtZSBJIGlkZW50aWZpY2Fyw6EgY2xhcmFtZW50ZSBzdS9zIG5vbWJyZS9zIGNvbW8gYXV0b3IvcwpvIHByb3BpZXRhcmlvL3MgZGUgbG9zIGRlcmVjaG9zIGRlIGV4cGxvdGFjacOzbiB5IG5vIGhhcsOhIG5pbmd1bmEgYWx0ZXJhY2nDs24KZGUgc3UgZG9jdW1lbnRvIGRpZmVyZW50ZSBhIGxhcyBwZXJtaXRpZGFzIGVuIGVzdGEgbGljZW5jaWEuCgpMYSBVbml2ZXJzaXRhdCBKYXVtZSBJIGFzaWduYXLDoSBhIHN1IGRvY3VtZW50bywgZW4gY2FzbyBxdWUgYXPDrSBsbyBoYXlhIGluZGljYWRvLApsYSBsaWNlbmNpYSBDcmVhdGl2ZSBDb21tb25zICBjb3JyZXNwb25kaWVudGUgcGFyYSBwcm90ZWdlciBsYSBwcm9waWVkYWQgaW50ZWxlY3R1YWwKZGVsIGF1dG9yIHkgZ2FyYW50aXphciBzdSByZXV0aWxpemFjacOzbiBlbiBsYXMgY29uZGljaW9uZXMgZXN0YWJsZWNpZGFzLiAK