• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

return calculated difference sql

Hi
I have the following query
select min(odometer) as odometer_min, max(odometer) as odometer_max
From dbo.MyTable
Where gpsDateTime >= '2018-01-01' and gpsDateTime < '2018-01-18' and eventID = 1

Open in new window


this returns 2 values

What i actually need to do is return the difference between the min and max

What would the sql be for this
0
websss
Asked:
websss
1 Solution
 
Scott PletcherSenior DBACommented:
select max(odometer) - min(odometer) as odometer_diff
From dbo.MyTable
Where gpsDateTime >= '2018-01-01' and gpsDateTime < '2018-01-18' and eventID = 1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now