SHARE
TWEET

Untitled

a guest Jun 17th, 2019 75 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table taTest(
  2. column1 varchar(50),
  3. column2 varchar(50)
  4. )
  5.      
  6. select distinct(column1),column2 from taTest;
  7.      
  8. desired output(for each query result) : column1value(column2value)
  9.      
  10. select wm_concat(distinct(column1)||'('||column2||')') as result  from taTest;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top