Skip to main content
2026-07-29 16:01
Database

Select All Records

QueryValidateEasy
Try Interactive Demo

What you will learn

  • Always specify columns (SELECT id, name), not SELECT * — schema changes break consumers silently otherwise
  • LIMIT without ORDER BY is non-deterministic — two identical queries can return different rows
  • Test edge cases: empty result, single row, exact-limit result, over-limit — each is a different code path

Description

Retrieve all users from the database.

Test Scenario

-- Your query:
SELECT * FROM users;

-- Expected: 5 rows with all user data
-- Columns: id, name, email, role, created_at, is_active

Testing Tips

  • •Use SELECT * to get all columns
  • •FROM specifies the table
  • •No WHERE clause needed for all records
// Playwright API Testing - Database
import { test, expect } from '@playwright/test';


test('Database query via API', async ({ request }) => {
  const response = await request.post('/api/database/query', {
    data: {
      sql: 'SELECT * FROM users WHERE id = ?',
      params: [1]
    }
  });


  expect(response.ok()).toBeTruthy();
  const { rows } = await response.json();
  expect(rows.length).toBeGreaterThan(0);
});

Challenge ID: sql-select-all

2 frameworks available