{"id":201,"date":"2017-05-15T21:51:25","date_gmt":"2017-05-15T21:51:25","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=201"},"modified":"2020-05-21T00:13:47","modified_gmt":"2020-05-21T00:13:47","slug":"consultas-filtrado-de-registros","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=201","title":{"rendered":"Consultas &#8211; Filtrado de registros con Where"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"290\" height=\"297\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ConsultasFiltrosD.png\" alt=\"\" class=\"wp-image-1408\"\/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Consultas &#8211; filtrado de registros<\/strong><\/h1>\n\n\n\n<p>Filtrar un conjunto de resultados permite listar los registros que cumplan con una o mas condicionesLos Filtros pueden ser especificados en campos de la tabla dentro de la cl\u00e1usula Where, y en listados con campos que tienen funciones de agregado en la cl\u00e1usula Having.<br>Para las expresiones l\u00f3gicas se utilizar los operadores de comparaci\u00f3n&nbsp;y los operadores propios de SQL. (Ver <a href=\"http:\/\/www.manualsqlserver.com\/?p=172\">Operadores en SQL<\/a>)<\/p>\n\n\n\n<!--more-->\n\n\n\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-2636008503986218\"\n     data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">Ejemplos<\/h3>\n\n\n\n<p>Los filtros con el operador Having se pueden encontrar en <a href=\"http:\/\/www.manualsqlserver.com\/?p=225\">Consultas con Agrupamientos<\/a> y <a href=\"http:\/\/www.manualsqlserver.com\/?p=207\">Funciones de agregado<\/a>.<\/p>\n\n\n\n<p>&#8212; Usando Northwind<br>use Northwind<br>go<\/p>\n\n\n\n<p><strong>Listas los productos con stock igual a CERO<\/strong><br>select * from Products where UnitsInStock = 0<br>go<\/p>\n\n\n\n<p><strong>Listar los clientes que son de las ciudades de Madrid, Barcelona y Sao Paulo<\/strong><br>select * from Customers<br>where City = &#8216;Madrid&#8217; or City = &#8216;Barcelona&#8217; or City = &#8216;Sao Paulo&#8217;<br>go<br><strong>Tambi\u00e9n se puede usar el operador In<\/strong><br>select * from Customers<br>where City in (&#8216;Madrid&#8217;,&#8217;Barcelona&#8217;,&#8217;Sao Paulo&#8217;)<br>go<\/p>\n\n\n\n<p><strong>Listar los productos con precios entre 20 y 40<\/strong><br>select * from Products where UnitPrice >= 20 and UnitPrice &lt;= 40<br>go<br><strong>Tambi\u00e9n se puede usar el operador Between<\/strong><br>select * from Products where UnitPrice between 20 and 40<br>go<\/p>\n\n\n\n<p><strong>Listar los empleados con 25 a\u00f1os o mas en el trabajo<\/strong><br>select E.EmployeeID As &#8216;C\u00f3digo&#8217;, E.LastName as &#8216;Apellido&#8217;,<br>E.FirstName As &#8216;Nombre&#8217; , A\u00f1os = DATEDIFF(yy, HireDate, GetDate())<br>from Employees As E where DATEDIFF(yy, HireDate, GetDate()) >= 25<br>go<\/p>\n\n\n\n<p><strong>Listar los Productos descontinuados con unidades en Stock<\/strong><br>select * from Products<br>where Discontinued = 1 and UnitsInStock >0<br>go<\/p>\n\n\n\n<p><strong>Listar los productos cuya descripci\u00f3n inicial con la letra C<\/strong><br>select * from Products<br>where ProductName Like &#8216;C%&#8217;<br>go<\/p>\n\n\n\n<p><strong>Listar los clientes cuyo contacto sea el Manager.<\/strong><br>select * from Customers where ContactTitle like &#8216;%Manager%&#8217;<br>go<\/p>\n\n\n\n<p><strong>Listar las \u00f3rdenes (Orders) que fueron atendidas despu\u00e9s de 5 d\u00edas.<\/strong><br>select O.OrderID As &#8216;N\u00ba Orden&#8217;, Format(O.OrderDate,&#8217;dd\/MM\/yy&#8217;) As &#8216;Fecha Registro&#8217;,<br>Format(O.ShippedDate,&#8217;dd\/MM\/yy&#8217;) As &#8216;Fecha Atenci\u00f3n&#8217;,<br>[D\u00edas de Espera] = DATEDIFF(d,OrderDate, ShippedDate)<br>from Orders As O<br>where DATEDIFF(d,OrderDate, ShippedDate) > 5<br>go<\/p>\n\n\n\n<p><strong>Listar los Empleados de la ciudad de Seattle en el pa\u00eds USA<\/strong><br>select * from Employees<br>where City = &#8216;Seattle&#8217; and Country = &#8216;USA&#8217;<br>go<\/p>\n\n\n\n<p><strong>Listar los proveedores (Suppliers) de France que no tienen asignada una Region (Null)<\/strong><br>select * from Suppliers where Country = &#8216;France&#8217; and Region is Null<br>go<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Consultas &#8211; filtrado de registros Filtrar un conjunto de resultados permite listar los registros que cumplan con una o mas condicionesLos Filtros pueden ser especificados en campos de la tabla dentro de la cl\u00e1usula Where, y en listados con campos que tienen funciones de agregado en la cl\u00e1usula Having.Para las expresiones l\u00f3gicas se utilizar los &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=201\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1408,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[127,51,126],"class_list":["post-201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-consultasdedatos","tag-filtros","tag-select","tag-where","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=201"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":1410,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions\/1410"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1408"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}