Query in database
Solved/Closed
Related:
- Query in database
- Borland database engine - Download - Databases
- Download ms access database - Download - Databases
- Database viewer - Download - Data management
- How to avoid duplicate records in sql select query - Guide
- MS Access database viewer - Download - Data management
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Aug 9, 2010 at 02:33 PM
Aug 9, 2010 at 02:33 PM
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.
Aug 10, 2010 at 03:03 AM