Guest User

Untitled

a guest
Jun 23rd, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT
  2. x.totalusers, x.totalusers*90 AS totalsalerys
  3. FROM (
  4. SELECT users*100 as totalusers FROM table
  5. ) x
  6.  
  7. SELECT (@r := users * 100) as totalusers,
  8. @r * 90 AS totalsalerys
  9. FROM table
Add Comment
Please, Sign In to add comment