Numeric data query examples
Sample queries for filtering motors based on different properties.
- Display Motor5 object
- SELECT * FROM Model WHERE BrowseName = 'Motor5'
- Display motors with Acceleration of 20
- SELECT * FROM Model WHERE Acceleration = 20
- Display motors with Acceleration of 20 and Speed between 300 and 500
- SELECT * FROM Model WHERE Acceleration > 20 AND Speed BETWEEN 30 AND 500
- Display motors of Names that start withFaulty
- SELECT * FROM Model WHERE BrowseName LIKE 'Faulty%'
Provide Feedback