SELECT t.*
  FROM (
         SELECT
           1      AS id,
           'text' AS txt,
           NULL   AS same
         UNION
         SELECT
           2      AS id,
           'text' AS txt,
           3      AS same
         UNION
         SELECT
           4 AS id,
           NULL AS txt,
           4 AS same
         UNION
         SELECT
           3 AS id,
           NULL AS txt,
           NULL AS same
       ) t
  ORDER BY COUNT(1) OVER(ORDER BY t IS NOT NULL DESC);