Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
abhijit dhanwate
1.9k
80
580
Use of Group by and aggregate function on given table
Feb 22 2021 7:42 PM
I have a below table
ContainerNumber Orgzn PO_Gross
------------------------------------------------------------------------------------------
MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 40
SZLU9006949 [ZL]Zestfruit (Pty) Ltd 30
MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 10
SZLU9006949 [ZL]Zestfruit (Pty) Ltd 50
TTNU8324679 [ZL]Zestfruit (Pty) Ltd 70
--------------------------------------------------------------------------------------------
Need Output in below format.
--------------------------------------------------------------------------------------------
ContainerNumber Orgzn PO_Gross
-------------------------------------------------------------------------------------------
MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 50
SZLU9006949 [ZL]Zestfruit (Pty) Ltd 80
TTNU8324679 [ZL]Zestfruit (Pty) Ltd 70
Reply
Answers (
2
)
How to give Efficent,better,latest Datatypes in sql server
Aggregate in SQL Server