날아보자!

데이터베이스 /* Database 생성 */ CREATE DATABASE UserTemp; /* Database List 출력 */ EXEC sp_databases; /* Database 삭제 */ IF EXISTS(select * from sys.databases where name='UserTemp') DROP DATABASE UserTemp 테이블 /* 테이블 생성 */ USE UserLabs; GO CREATE TABLE dbo.UserTbl ( USERID INT PRIMARY KEY IDENTITY (1, 1), NAME VARCHAR(10), AGE INT, ADDR VARCHAR(20) ) CREATE TABLE dbo.UserSales ( USERID INT PRIMARY KEY IDEN..

MSSQL MySQL 결과 날짜함수 (yyyy-mm-dd hh:mm:ss.sss) convert(datetime, getdate(), 102) DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s') 2021-11-08 12:18:10.730 날짜함수 (yyyy.mm.dd) convert(varchar(10), getdate(), 102) DATE_FORMAT(NOW() , '%Y.%m.%d') 2021.11.08 날짜함수 (yyyy-mm-dd) convert(varchar(10), getdate(), 23) DATE_FORMAT(NOW() , '%Y-%m-%d') 2021-11.08 날짜더하기 dateadd(day, 1, getdate()) DATE_ADD(NOW(), INTERVAL 1..

1. w3schools https://www.w3schools.com/SQL/trymysql.asp?filename=trysql_func_mysql_instr MySQL Tryit Editor v1.0 WebSQL stores a Database locally, on the user's computer. Each user gets their own Database object. WebSQL is supported in Chrome, Safari, and Opera. If you use another browser you will still be able to use our Try SQL Editor, but a different version, usin www.w3schools.com 2. sqlfidd..

Julia conducted a 15 days of learning SQL contest. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. Write a query to print total number of unique hackers who made at least 1 submission each day (starting on the first day of the contest), and find the hacker_id and name of the hacker who made maximum number of submissions each day. If more than one such hacker..