Posts by Vilma • 11 points
3 posts
-
-1
votes2
answers153
viewsA: Count in the Postgresql database
Solution found: SELECT COUNT(*) FROM tb_client WHERE EXTRACT(YEAR FROM dt_cadastre) = 1980;
-
0
votes2
answers153
viewsQ: Count in the Postgresql database
Good morning . I wanted to select in my bank and return the number of registered . Example: tb_client; column: dt_register; in the dt_register column I have this: 2000-01-20 2001-10-05 1990-11-09…
-
1
votes0
answers23
viewsQ: Compare Year and Count Registered in Bank
I wanted to count registered clients in my bank, born in the year 1930 until the current year (2017). In my bank I have registered as date, date of birth ex: 2000-10-01 So I wanted to make one for…