how to add row numbers (record counting) to access query field

Basic SQL Queries (Part 1) Learning SQL? 🤔 Here are the first 4 steps to get started ⬇️ 1️⃣ Create Database 🗂️ CREATE DATABASE my_database; 2️⃣ Create Table 📋 CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(50), department VARCHAR(50), salary DECIMAL(10,2) ); 3️⃣ Insert Data ✍️ INSERT INTO employees (id, name, department, salary) VALUES (1, 'John Doe', 'IT', 50000); 4️⃣ Select All Data 🔍 SELECT * FROM employees; 💡 That’s it! You just created your first database, added data & retri