Posts by Maux • 45 points

• 1

  votes

  1

  answer

  290

  views

  Q: SQL Query to Group Records in MS-ACCESS

  Hello, I would like an SQL command for a query in a Access. The structure of the table is: tbList Id | Nome | Genero | Endereco | Estado | ... The result I would like to group by state and count the…

  sql query ms-access

  asked 6 years ago Maux 45

• 3

  votes

  1

  answer

  258

  views

  Q: Random Records with Criteria

  I would like some SQL command for a MS-Access database where I have 500 records and only to return 20 records so random being these (10 FEMININE and 10 MALE) and sorted in alphabetical order by…

  sql ms-access

  asked 6 years, 1 month ago Maux 45