Advertisement
Guest User

Untitled

a guest
Jul 6th, 2018
302
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #одна колонка, смотрим как объекты
  2. SELECT *
  3. FROM
  4.   (SELECT *
  5.    FROM
  6.      (SELECT objects."id" AS "objects_id",
  7.              objects.id AS "abc",
  8.              objects."Enabled" AS "objects_Enabled",
  9.              objects."Transport" AS "objects_Transport",
  10.              to_timestamp(to_char(objects."LastLogin"::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE AS "objects_LastLogin",
  11.                                                                                                                                                                                                       ,....,
  12.                                                                                                                                                                                                       objects."Testval" AS "objects_Testval"
  13.       FROM appobjects
  14.       LEFT JOIN objects ON objects.id = appobjects."ObjectId"
  15.       WHERE objects.id IS NOT NULL
  16.         AND appobjects."ApplicationId" = 672) a
  17.    WHERE ("objects_Email"='nzulfigarov@gmail.com')) ol
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement