1

I have the following columns

uName1, uName2 ...... uName30

Since the name's length is long, if will be very difficult for me to read the screen using developer console and SOQL like this

select uName1, uName2 ...... uName30 from tbName

Is there anyway I can achieve the result like using union in SQL

Select uName1 Union Select uName2 Union ...

P/s : export data by DataLoader into excel is not an option, I can only use the Developer Console

Improve this question
1
  • 1
    Are you looking to use a query union to truly combine the result-set of two or more different tables or are you more interested in the formatting it can offer? If the latter, using indentation and line breaks works. Commented Mar 10, 2021 at 10:08

1 Answer 1

Reset to default
2

No, SOQL doesn't support query unions. Limiting yourself to only the Developer Console means you have no other options available to you.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.