# SQL Server: Incorrect syntax near 'x'. (Msg 102)

**Code:** `102` · **Category:** SQL · **Seen on:** SQL

T-SQL couldn’t parse the statement near the shown token.

## Meaning

MySQL/PostgreSQL syntax (LIMIT, backticks, ILIKE), missing commas, reserved words, or unsupported features for the compatibility level.

## Common causes

- LIMIT instead of TOP/OFFSET FETCH
- Backticks instead of [brackets]
- Reserved words as names
- Old compatibility level

## Quick fix

1. Use TOP or OFFSET … FETCH
2. Quote identifiers with [ ]
3. Check the database compatibility level

## Detailed fix by platform

### SQL

1. `SELECT * FROM dbo.Orders ORDER BY Id OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;`

## How to diagnose

1. **Token** — Which one?
2. **Dialect** — Non-T-SQL syntax?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/mssql-incorrect-syntax-near-102)