Skip to main content

Search This Blog

Lazy ICT Dictionary

An ICT Dictionary for HKDSE Student

Home
Intro
Other
中

Posts

Showing posts from November, 2024

November 05, 2024

ALTER TABLE

November 05, 2024

WHERE/HAVING

Newer Posts Older Posts Home

Powered by Blogger

Theme images by Deejpilot

(c) My Head No Hair 2024-2025

My Head No Hair

INDEX

Spreadsheet1
SQL33

SPREADSHEET

Spreadsheet function

XLOOKUP()

SQL

SQL concept

Data integrity
Database Normalization

SQL keyword

SQL Data Type
CREATE
CONSTRAINT
SHOW
USE
DROP
INSERT INTO
UPDATE
ALTER TABLE
SELECT
WHERE/HAVING
DELETE FROM

SQL function

SQL Basic Function
AVG()
COUNT()
MAX()
MIN()
SUM()
DATE()
DAY()
MONTH()
YEAR()
LEN/LENGTH()
MID()
SPACE()
TRIM()
LOWER()
UPPER()
ABS()
CHAR/CHR()
INT()

Report Abuse

Archive

2025 3
- June 1
- May 1
- January 1

2024 31

Show more Show less