Posts by Rafael Guerreiro • 96 points
3 posts
-
0
votes1
answer105
viewsA: How to create two different menus and activate responsive with different measures?
You can use the css classes ". Hidden-Xs", ". Hidden-Sm", ". Hidden-Md". Follow the link in the documentation: http://getbootstrap.com/css/#Responsive-Utilities…
twitter-bootstrapanswered Rafael Guerreiro 96 -
1
votes2
answers882
viewsA: Subselect in the same column
You can do Join in the same table, no problem: select fil.idUnidadeOrganica as id_filha, fil.NmUnidadeOrganica as nm_filha, mae.idUnidadeOrganica as id_mae, mae.NmUnidadeOrganica as nm_mae from…
-
7
votes3
answers8471
viewsA: Is a subquery in SELECT calculated for each result or just once?
As done, Count will run for each row of the select. The same would be if you used the subquery in the Where clause. For you to execute this second Count only once, just make a Cartesian plan: SELECT…
sqlanswered Rafael Guerreiro 96