Issue with Group by clause

Hi All,

I need some guidance from you to fetch the data using group by clause .

How to get data based on below tables and  selected columns with group by.(with out specifying all columns in group by how to get the data).?

Find all Items where changes have been made by a vendor over the past one day.

• Item name/barcode
• Description
• Vendor ID
• Vendor name
• Item Unit length, width, height & weight
• item quantity
• Modified by
• Modified datetime

Group by org_id, Vendor_id

tables:

-------

1) Item (item_id column, Item Unit length, width, height & weight,qty columns)

2) Vendor(vendor_id column)