Closed. This question needs to be more focused。它当前不接受答案。
                            
                        
                    
                
                            
                                
                
                        
                            
                        
                    
                        
                            想改善这个问题吗?更新问题,使其仅通过editing this post专注于一个问题。
                        
                        3年前关闭。
                                                                                            
                
        
使用sql,如何通过查询找到第二大数字?

最佳答案

或使用限制:

SELECT number
FROM numbers
WHERE 1=1
ORDER BY number DESC
LIMIT 1, 1

10-07 16:35
查看更多