The following SELECT statement selects all rows and all columns from the RCC_Media view:
SELECT * FROM DBC.RCC_MediaV;
Result:
EventNum VolSerialID VolSequenceNum DupeDumpSet -------- ----------- -------------- ----------- 21 KAZ002 1 N 76 RDB003 1 N 66 RDB007 1 N 19 KAZ002 1 N 66 RDB008 2 N 37 MET001 1 N 77 RDB003 1 N . . . . . . . .