Final exam questions from projects

Re: Final exam questions from projects

by Jeremy Novak -
Number of replies: 0

The client wants to display an Access Database column with the header Time. Time is a reserve word. Can Time be used as a column header? If so write a short SQL statement that uses Time as a column header and a sample column that could be displayed.

Answer: Yes

SELECT StartTime AS ‘Time’

FROM TableName;