SQL Query Multiple Columns Using Distinct on One Column Only

Solution

select ID, Category from t_Con_ChargesAmount where
 ID in (Select max(ID) FROM t_Con_ChargesAmount group by Category)

This query will select ID and Category from the table and the Category will be distinct now.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (Address never made public)

Name

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

	Bug Fixes & Codi… on Contact
	Simon on Convert Excel file to PDF usin…
	Bug Fixes & Codi… on Contact
	Bug Fixes & Codi… on Object Operators in PHP
	BestJustina on Object Operators in PHP