clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3609693 fiddles created (47127 in the last week).

CREATE TABLE customers ( id int NOT NULL, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, city VARCHAR(50) NOT NULL, state VARCHAR(5), PRIMARY KEY (id) ); INSERT INTO customers (id, first_name, last_name, city, state) VALUES (1, 'François', 'Tremblay', 'Montreal', 'QC'), (2, 'Bjørn', 'Hansen', 'Oslo',null), (3, 'Helena', 'Holý', 'Prague', null), (4, 'Fernanda', 'Ramos', 'Brasília', 'DF'); SELECT query_to_xml( 'SELECT "Id" , t.first_name "FirstName" , t.last_name "LastName" , "City" , t.state "State" FROM customers t LIMIT 2', true , false, '')
4 rows affected
<table xmlns:xsi=""> <row> <Id>1</Id> <FirstName>François</FirstName> <LastName>Tremblay</LastName> <City>Montreal</City> <State>QC</State> </row> <row> <Id>2</Id> <FirstName>Bjørn</FirstName> <LastName>Hansen</LastName> <City>Oslo</City> <State xsi:nil="true"/> </row> </table>
 hidden batch(es)