Blog Archives

Entries Tagged as 'MySQL'

How to get one row in MySQL and MS SQL Server

Posted on : Jan 19
Posted by : Matt Graf

Filed under: Microsoft SQL Server , MySQL , snippet , SQL

This is just reference for me, I am always forgetting how get just one row in MySQL.

Select one row with MySQL:

view plain print about
1SELECT column FROM table
2LIMIT 1

Select one row with Microsoft SQL Server:

view plain print about
1SELECT TOP 1 column FROM table


Go Top