jgdoncel/if.sql

Created October 2, 2013 13:52

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jgdoncel/6794152.js"></script>
Save jgdoncel/6794152 to your computer and use it in GitHub Desktop.

Download ZIP

IF en subconsulta Ejemplo de uso de una condición IF con una subconsulta en su interior

Raw

if.sql

SELECT DISTINCT files.contentType, IF ((SELECT COUNT(id) FROM files_favoritos)=0,'si','no') FROM files

ddiazr3 commented Nov 29, 2019

SELECT DISTINCT files.contentType, IF ((SELECT COUNT(id) FROM files_favoritos)=0,'si','no') FROM files

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment