Member Avatar for srinidelite

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

  • 4 Contributors
  • 4 Replies
  • 64 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by srinidelite
Anuradha Mandal commented: Not clear. +0
adam_k commented: manners -1

Recommended Answers

All 4 Replies

Member Avatar for debasisdas

error.

Member Avatar for anand01

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

Member Avatar for diafol

answer it SOON

Learn some manners and people may help you.

Member Avatar for srinidelite

what manner ?? could u tel ??

commented: LEARN MANNERS. -3
Be a part of the DaniWeb community

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