Shulou(Shulou.com)06/01 Report--

This article mainly introduces in detail the methods of sqlserver multi-table joint query and multi-table paging query, the detailed explanation of picture and text is easy to learn, and the effect of reading comprehension with the code is better, which is very suitable for beginners. Interested friends can refer to it.

Multi-table joint check:

[ProductRecordInfo]-- table name p left join [ShengInfo] s on p.ShengInfo = s.ShengId-- use left join left join to create a join relationship between specified fields in two tables left join [ShiInfo] I on p.ShiInfo = i.ShiId-- use left join left join to create a join relationship between specified fields in three tables

The on here is similar to where, and the later conditions can be written by yourself.

The running results are as follows:

Paging Sql statement:

Numbering using the row_number () function

Select * from (select ROW_NUMBER () over (order by Id ASC) as IDD, * from ProductRecordInfo) a where a.IDD > = 1 and a.IDD

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.