Common SQL Functions

Core aggregate functions like SUM, COUNT, MAX, MIN
Ranking functions like ROWNUM, RANK, NTILE
String functions like SUBSTR, REPLACE,INSTR
Data conversion functions like CAST, CONVERT