rose tinted glasses

  • 홈
  • 태그
  • 방명록
rose tinted glasses

substring 1

[Udemy] 15 Days of SQL - Day 4 ① : Functions(LENGTH, LOWER, UPPER, LEFT, RIGHT), Concatenate, POSITION, SUBSTRING

1. LOWER & UPPER, LENGTH Syntax SELECT LOWER (email) AS email_lower, email, LENGTH(email) FROM customer WHERE LENGTH(email) < 30 * Challenge Write a query to find customers whose either the first name or the last name is more than 10 characters long. Output the list of these first and last names in all lower case. SELECT LOWER(first_name), LOWER(last_name), LOWER(email) FROM customer WHERE LENGT..

Data Science/SQL 2024.02.20
이전
1
다음
더보기
프로필사진

rose tinted glasses

  • 분류 전체보기 (60)
    • Post Graduate (0)
    • Python (28)
      • TIL (4)
      • Git & GitHub (4)
      • BaekJoon (4)
    • Java (18)
    • Data Science (8)
      • SQL (7)
    • English (6)
      • Cambly (2)

Tag

leftouterjoin, timestamp, Extract, where, udemy, 15daysofSQL, Between, HAVING, groupby, RIGHTOUTERJOIN, SQL, count, CONCATENATE, caseWhen, LIMIT, 점프투자바 #JAVA #제어문, COALESCE, PostgreSQL, TIL #딕셔너리 #파이썬 #get, orderby,

최근글과 인기글

  • 최근글
  • 인기글

최근댓글

공지사항

페이스북 트위터 플러그인

  • Facebook
  • Twitter

Archives

Calendar

«   2026/02   »
일 월 화 수 목 금 토
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28

방문자수Total

  • Today :
  • Yesterday :

Copyright © Kakao Corp. All rights reserved.

티스토리툴바