Difference between mysql limit and mssql top

Let's take a look today.

The difference between mysql limit and mssql top is that when you don't pay attention to it, limit and top are the same usage, but the two are used in different SQL statements. limit can only be used in mysql, such

Select * from bb limit 0, 10

The above indicates getting 10 from 0th long. Let's take a look at mssql top.

Select Top 10 from bb

Ten, but only the first 10, so that top is no limit, right.

Now mysql uses limit $ start and $ pagesize for paging, which is much more convenient and saves server resources.

Well, I won't talk about the difference. You should have understood it,

The following statement is as follows. For original reposted on this site, please note: www.111cn.cn