Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select (select Value from table1 t where t.time1 = (select max(time1) from table1)) / avg(Value) as Result
- from table1 t
- where t.time1 <> (select max(time1) from table1);
- +--------+
- | Result |
- +--------+
- | 4.1126 |
- +--------+
Add Comment
Please, Sign In to add comment