Pb is a hand, and help you greatly, how to realize averaging in view, and how is the view in the data window display, built the data window can only connection form, with pb9.0,, look at greatly people glad,, thank you very much,,

CodePudding user response:

Select col1, col2, (col1 and col2) avg from table_name

CodePudding user response:

refer to the original poster u012745197 response:

pb a bitter hands, and help you greatly, how to realize averaging in view, and how is the view in the data window display, built the data window can only connection form, using a pb9.0,, look at greatly people glad, thank you very much,,

If you need to achieve average in view, need to use Group by, written SQL check yourself

View the data window is exactly the same, and table shows the pb data window does not distinguish between views or tables

CodePudding user response:

Thanks to lota,, thanks to the moderator, greatly, hard hard