Sql

Search

xml path sql server

SELECT TOP(1) issue_code,
    abc = 
    STUFF (
        (SELECT TOP(100)   
                ',' +issue_code  
        FROM rrf_tbl
        FOR XML PATH('')), 1, 1, ''
    )
FROM rrf_tbl GROUP by issue_code

Comment

PREVIOUS	NEXT

Code Example
Sql :: t sql get foreign key
Sql :: Copy Table from SQL to CSV
Sql :: clear a table in mysql
Sql :: how select a json value in mysql
Sql :: select latest entry in sql table
Sql :: select from describe sql
Sql :: postgresql drop table
Sql :: list all columns in a table sql
Sql :: mysql select and count left join
Sql :: trigger in postgresql to change incoming entry
Sql :: sql delete caracter list
Sql :: create new table from existing table with data in sql server
Sql :: sql server set variable if exists
Sql :: phone number sql
Sql :: where date = max(date) in sql
Sql :: find duplicate users by email address in mysql
Sql :: get value from a table an insert it with other values in another table sql
Sql :: truncate table postgres
Sql :: postgres copy table from one schema to another
Sql :: select distinct
Sql :: SQL COUNT() with DISTINCT
Sql :: psql get table data types
Sql :: creating a table in sql
Sql :: trim sql oracle
Sql :: oracle nextval insert
Sql :: mysql generate uuid
Sql :: username sql
Sql :: sql select where more than one record exists
Sql :: group_concat in mysql
Sql :: sql pad left 0

Search

SQL

xml path sql server

ADD CONTENT