Posts by Goustkor • 11 points
2 posts
-
1
votes2
answers757
viewsA: Create report displaying total and subtotal
You can use DISTINCT from SQL, it takes all the values of a tab, and takes 1 single example of each. Table (User): User | Empresa A | Google B | Facebook C | Google D | Facebook SELECT DISTINCT…
-
0
votes3
answers189
viewsA: SQL - Restrict query data
You can use the SQL search parameters system. When you use: SELECT [nome] FROM [colaboradores]; It Grabs all contributors, since you don’t set a search parameter. SELECT [nome] FROM [colaboradores]…