Table A(line_key,transaction_no,transaction_amt)
Which is the o/p of the following query??
Select line_key,transaction_no,sum(Transaction_amt)From A;

Ans 1. all the rows from the above table
2.no rows at all
3.error

post your reply soon

Anuradha Mandal commented: Not clear. +0
adam_k commented: manners -1

all the rows but sum value of Transaction_amt will be displayed in each row

Member Avatar

answer it SOON

Learn some manners and people may help you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.