Profile My skills Saved Collections Edit profile Submit a skill

SQL

Database query language.

dhaupin 959eaa5 746 B Updated
Data & Analytics

File contents

SQL

Database query language.

When To Use

  • Database queries
  • Data analysis
  • CRUD operations

What To Do

1. Basic

SELECT columns FROM table
WHERE condition
ORDER BY column
LIMIT n

2. Operations

Keyword What
SELECT Read
INSERT Create
UPDATE Update
DELETE Remove
JOIN Combine

3. Aggregates

SELECT COUNT(*), SUM(col), AVG(col), MIN(col), MAX(col)
FROM table
GROUP BY col
HAVING count > 1

4. Subqueries

SELECT * FROM users
WHERE id IN (SELECT user_id FROM orders)

Role: SQL Developer
Input: Query
Output: Results

Query.

dhaupin/vant/tree/main/models/public/skills/vant-skill-sql commit 959eaa5be5

Browse category

Frequently asked questions

npx skillmds@latest add dhaupin/sql