sql queries code example
Example 1: css in sql query
SELECT 'test1' AS [@class]
, ( SELECT 'test2' as [@class]
, (SELECT 'Name' FOR XML PATH(''))
FOR XML PATH('td'), type)
,(SELECT 'test3' as [@class]
, (SELECT 'Value' FOR XML PATH(''))
FOR XML PATH('td'), type)
FOR XML PATH('tr'), type
Example 2: SQL
CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id, name, birthday)
VALUES (1, 'Jane Doe', '1990-05-30');
INSERT INTO friends(id , name , birthday)
VALUES(2 , 'APOORV' , '2000-2-2');
UPDATE friends
SET name = 'Jane Srivastava'
WHERE id = 1;
ALTER TABLE friends
ADD COLUMN email TEXT;
UPDATE friends
SET email = '203029@klsafjls'
where id = 1;
UPDATE friends
SET email = '203029@klsafjls'
where id = 2;
DELETE FROM friends
WHERE id = 1;
SELECT *
FROM friends;
Example 3: sql queries
sql queries
Example 4: Database Queries
ALTER TABLE table_name ADD column_name datatype;
Example 5: sql syntax
select [all/distinct] , ,
from
[join ]
[where ]
[group by ]
[having ]
[order by ]
/*
Specifically for SQL -> Oracle
LEGEND:
[...] : optional entries
<...> : your specific entry
*/
Example 6: all sql commands with examples
DROP DATABASE db_name;