注意:此页面搜索的是所有试题
                题目内容
                (河南财经政法大学-数据库基础与应用)
            
            
                [多选题,10分] 现有书目表book,包含字段:price (float); 现在查询一条书价最高的书目的详细信息,以下语句正确的是
A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price= (select max (price)from book)
D.select top 1 * from book where price= max(price)
                    
                    
                    
                
                
                
            
        A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price= (select max (price)from book)
D.select top 1 * from book where price= max(price)
参考答案
 
                