Posts by nildowjunior • 91 points
3 posts
-
4
votes3
answers264
viewsA: Receive a string and put keys in it
To display the characters { and } literally you will need to "escape" them by adding the same character a second time. That is, to present the value { you need to write {{ Since you still want to…
-
1
votes3
answers121
viewsA: Compare birth date registered in the database to a custom date - mysql
As commented in another reply Mysql uses alias for the fields but does not allow references to them in WHERE. However, you can use a clause HAVING. HAVING will only be evaluated after the…
-
4
votes2
answers79
viewsA: Do an SQL sub-query
In some Dbms it is possible to perform a filter when using an aggregation function, such as Count. This avoids several nested queries. In Postgres, for example, your query could be written as…
sqlanswered nildowjunior 91