How to get one row in MySQL and MS SQL Server
This is just reference for me, I am always forgetting how get just one row in MySQL.
Select one row with MySQL:
1SELECT column FROM table
2LIMIT 1
2LIMIT 1
Select one row with Microsoft SQL Server:
1SELECT TOP 1 column FROM table

Loading...