Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
DBMS 4/9/20
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE Global_Developers(id INTEGER, Name VARCHAR(36), Skills VARCHAR(100), Experience INTEGER, Certifications VARCHAR(100), Nationality VARCHAR(50) ) INSERT INTO Global_Developers values (1, 'John Doe', 'Web, Android, ios', 8, 'Google Android Developer', 'USA'), (2, 'Robert Oreilly', 'Website, SEO, Content Writing',3 , 'Nothing', 'Brazil'), (3, 'Jane Doe', 'Machine Learning, Deep Learning, Artificial Intelligence', 6, 'PCAP', 'Europe') UPDATE Global_Developers set Certifications = null where id = 2 SELECT * FROM Global_Developers SELECT * FROM Global_Developers ORDER BY Experience DESC SELECT id,Name,Skills FROM Global_Developers Where Skills LIKE '%Web%' SELECT id,Name,Skills FROM Global_Developers Where Nationality='USA' or Experience>5 SELECT id,Name,Skills FROM Global_Developers Where Nationality='Brazil' and Experience=3 SELECT id,Name,Skills FROM Global_Developers Where Certifications is NOT null SELECT id,Name,Skills FROM Global_Developers Where Certifications is null
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Transpose group per sequence
My notes
Practice
SQL Stringdata
select all tables from given schema
My data
practice sql_12AUG_Upddated
repert
Demo
Window Functions - ROW_NUMBER()
Please log in to post a comment.