Query in database
Solved/Closed
Related:
- Query in database
- Access database download - Download - Databases
- Borland database engine download - Download - Databases
- Facebook database download - Guide
- Open office database download - Download - Office suites
- Microsoft access database viewer - Download - Data management
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
9 Aug 2010 à 14:33
9 Aug 2010 à 14:33
Yes you an query any database (if you have permissions to tables and columns)
How can you get a count depends the structure of the table
SELECT PERSON_ID, count(*) from mytable group by PERSON_ID
this statement is grouping data on a column person_id, and for each person_id gives you a total
This is just an example. The sql depends on table layout.
How can you get a count depends the structure of the table
SELECT PERSON_ID, count(*) from mytable group by PERSON_ID
this statement is grouping data on a column person_id, and for each person_id gives you a total
This is just an example. The sql depends on table layout.
10 Aug 2010 à 03:03