How to select specific column in SQL Queries?

Wilbye Descalsota

Question

I want to select a specific column from a table.

My Code is

SELECT {TableName}.[Column1] from {TableName}

and Get error that says "Column count doesn't match structure attribute count"

17 Sep 2020

Nikhil Purohit

Hi Wilbye,

You will require to create a structure with data type of {TableName}.[Column1] and then use it in the output structure of your SQL query.

This will execute your query for sure.

Regards,

Nikhil

17 Sep 2020

JitendraYadav

Wilbye Descalsota wrote:

I want to select a specific column from a table.

My Code is

SELECT {TableName}.[Column1] from {TableName}

and Get error that says "Column count doesn't match structure attribute count"

Hi,

You are getting an error bcoz the output structure not matched. to solve this issue create a new structure with desire columns in your case one attribute in structure and bind that structure as an output.

Thanks

17 Sep 2020

Vijay Malviya

Hi Willbye,

You need define cloumn in select statement to correspond to output structure.

Correct way:

Hope this will help you!

Vijay M-

17 Sep 2020

Wilbye Descalsota

All of the replies were right, structure is required for the columns to be selected. Thank you guys

22 Sep 2020

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines