Skip to main content

Peliqan

Try for free
Request a demo

GeoDynamics

Top 5 resourcegroups by number of resources

SQL query for GeoDynamics

List the top 5 resourcegroups by the number of resources they contain.

SELECT resourcegroup_id, COUNT(*) AS resource_count FROM resources GROUP BY resourcegroup_id ORDER BY resource_count DESC LIMIT 5

Try this query now in GeoDynamics

GeoDynamics data model

GeoDynamics
Resource Types

View 2 columns
NameString
Resource_TypeNumber
GeoDynamics
Resourcegroups

GeoDynamics
Resources

GeoDynamics
Vehicles

GeoDynamics
Timeclocks

GeoDynamics
Point Of Interests

GeoDynamics
Poigroup

GeoDynamics
Poitype

GeoDynamics
Rfidtags

GeoDynamics
Mobile Rfid Scanners

GeoDynamics
Smartphones

GeoDynamics
Users

GeoDynamics
Overtimeconfigs

GeoDynamics
Clockings

GeoDynamics
Costcenters

GeoDynamics
Costcenter Validators

GeoDynamics
Day Programs

GeoDynamics
Assets

GeoDynamics
Asset Locations

GeoDynamics
Asset Inspection Types

GeoDynamics
Asset Identifications

GeoDynamics
Absencetypes

GeoDynamics
Access Schedules

GeoDynamics
Access Schedules Exceptions

GeoDynamics
Accessgroups

GeoDynamics
Access Locations

GeoDynamics
Maintenance

GeoDynamics
Vehicle Maintenance Tasks

GeoDynamics
Maintenance Types

GeoDynamics
Badges

GeoDynamics
Btw Numbers

GeoDynamics
Persons

GeoDynamics
Persons Limosa

GeoDynamics
Workplaces

GeoDynamics
Project Leads

GeoDynamics
Registrations

GeoDynamics
Mobileclocking Optionlist

GeoDynamics
Mobileclocking Multijoblist

GeoDynamics
Fleet Fuelsensors

GeoDynamics
Post Calculation Events

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed