Pegasystems
PEGACRSA80V1 · Question #49
You have a requirement that must return the OrderDate, OrderStatus, and OrderAmount for all orders for a given customer account in a SQL database. How should the SQL query be specified in the…
The correct answer is D. SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where. See the full explanation below for the reasoning.
Question
You have a requirement that must return the OrderDate, OrderStatus, and OrderAmount for all orders for a given customer account in a SQL database. How should the SQL query be specified in the CommanoText property of the SqIQuery component?
Options
- ASELECT OrderDate, OrderStatus, OrderAmount FROM Orders where
- BSELECT OrderDate, OrderStatus, OrderAmount FROM Orders where
- CSELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber={0}
- DSELECT OrderDate, OrderStatus, OrderAmount FROM Orders where
How the community answered
(47 responses)- A6% (3)
- B13% (6)
- C4% (2)
- D77% (36)
Community Discussion
No community discussion yet for this question.