[pgsql-jp: 36221] Re: DISTINCT で重複して検索される

[Sato_Kenichi]

すみません、訂正です。

>SELECT DISTINCT 'X'||Name||'X' FROM tbl1 ORDER BY Name;

SELECT DISTINCT 'X'||Name||'X' as Name FROM tbl1 ORDER BY Name;


---
佐藤 研一
E-Mail: satok-point ＠ mf.point.ne.jp