1

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы для программистов

-- --
-- http://ru.stackoverflow.com/election/1
-- Array.prototype.map.call($$(".post-signature.owner.candidate-score .user-details a"), a => a.href.match(/\d+/)[0]) + ''
-- 181472,15479,177221,182317,176610,178988,176051,178018
-- --
-- select * from Users where Id in (181472,15479,177221,182317,176610,178988,176051,178018)
-- --

select
  Id,
  DisplayName as Имя,
  Reputation as Репутация,
  UpVotes,
  DownVotes,
  cast(round(100.0 * UpVotes / (UpVotes+DownVotes), 3) as dec(8,3))
from
  Users u
where
  u.Id in (181472,15479,177221,182317,176610,178988,176051,178018)
order by
  u.Reputation desc

view current version

edited dec 18 15

created dec 17 15 Qwertiy