MySQL limit and MSSQL top difference

Today we're going to take a look

MySQL limit is different from the MSSQL top, limit is the same usage as top, but two are in different SQL, limit can only be used in MySQL, such as

select * FROM BB limit 0,10

It says 10 from the No. 0. Okay, let's take a look at MSSQL top.

Select top from BB

Also take 10, but only the first 10, so top is not limit convenient is it.

Now MySQL paging will use the limit $start, $pagesize so much more convenient, but also save the resources of the server.

All right, I will not tell you the difference, you should understand it,

Here is a statement. Original site reproduced please specify: www.111cn.net