SQL

Standard

1) Table W_FACT_T_F has two columns ROW_WID,METRIC. Write a Single Update Statement to update metric=500 for row_wid less than 10000 and metric=900 otherwise.

This query is an example of correlated sub query.

Update Statement:

No comments:

Post a Comment