Skip to main content

Search This Blog

Lazy ICT Dictionary

An ICT Dictionary for HKDSE Student

Home
Intro
Other
中

Posts

Latest posts

Database Normalization

Data integrity

January 02, 2025

Spreadsheet Function: XLOOKUP()

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

2024 31
- December 21
- November 2
- August 4
- May 4

Show more Show less