Shulou(Shulou.com)05/31 Report--

What this article shares with you is about how to exclude duplicate results in SQL. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

How to use SQL to exclude records that only take the maximum value of the field as a result of repetition? The required result (that is, the record with the same PID takes only the one with the highest ID value). The copy code is as follows: select * from [Sheet1 $] awhere ID not exists (select 1 from [Sheet1 $] where PID=a.PID and ID > a.ID)

Select a.* from [Sheet1 $] an inner join (select PID,max (ID) as max_id from [Sheet1 $] group by PID) b on a.PID=b.PID and a.ID=b.max_id

The above is how to exclude repetitive results in SQL. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.