Working with MySQL and SQL Server together has its own sets of fun. Here is one example how you can implement paging in MySQL or SQL Server. Both of them have LIMIT and OFFSET mechanism. You can Skip few rows and return few rows from the sorted result set with the help of OFFSET keywords. Let us see how we can do that quickly in the both of the database. We will use AdventureWorks sample database for SQL Server and sakila sample database for MySQL.
If you are working in IT industry, you must encounter software developer around every corner of the office. I am developer myself and pretty much my all friends are developers too. I have created a list of phrases which developer use often. Feel free to add one of yours as a comment as well.
