Query in database
Solved/Closed
Related:
- Query in database
- Access database download - Download - Databases
- Borland database engine download - Download - Databases
- How to avoid duplicate records in sql select query - Guide
- Client server database architecture - Guide
- Patient database free download - Download - Organisation and teamwork
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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