Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Asterisk

An asterisk, '*', used in the select list refers to all columns of the table that is specified in the FROM clause. Each column of the table is included exactly once in each row of the query results.

To select all the columns of a table or correlation, use ".*' (dot asterisk) as the suffix as shown in the following example:

     SELECT mytable.* FROM mytable

When an asterisk is used in the select list, the column names as defined for the table are used as the label when accessing the columns in the rows of the query result.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.