查看表PRODUCTS的LIST_PRICE和MIN_PRICE字段,哪两个表达式能得到一样的结果()
A: NVL(NULLIF(list_price,min_price),0)
B: NVL(COALESCE(list_price,min_price),0)
C: NVL2(COALESCE(list_price,min_price),min_price,0)
D: COALESCE(NVL2(list_price,list_price,min_price),0)
A: NVL(NULLIF(list_price,min_price),0)
B: NVL(COALESCE(list_price,min_price),0)
C: NVL2(COALESCE(list_price,min_price),min_price,0)
D: COALESCE(NVL2(list_price,list_price,min_price),0)
举一反三
- 查询book表中price字段的最大值,查询语句是: A: select max(price) from book; B: select min(price) from book; C: select price from min book; D: select price from max book;
- Is the latest price list on CIF basis?
- 以下代码的输出结果是()。publicclassTest{publicstaticvoidmain(String[]args){double[]price=newdouble[5];price[0]=98.10;price[1]=32.18;price[2]=77.75;System.out.print((int)price[0]+""+(int)price[1]+""+(int)price[2]+""+(int)price[3]+""+(int)price[4]);}}
- BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。显示图书的最高价、最低价、平均价、最高价与最低价之间的差值。SQL语句:SELECTMAX(Price)As最高价,MIN(Price)As最低价,Str(AVG(Price),6,2)As平均价()As最高价与最低价的差值FromBook A: (MAX-MIN)Price B: MAX(Price)-MIN(Price) C: (MAX-MIN)(Price) D: MAX:Price-MIN:Price
- The new price list will become effective ______ October 1.