ahouts/select-most-recent-fee-trade.sql

Created October 31, 2025 15:06

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ahouts/b7cd6f6970b8e592984364c5e26c5e99.js"></script>
Save ahouts/b7cd6f6970b8e592984364c5e26c5e99 to your computer and use it in GitHub Desktop.

Download ZIP

Selecting the most recent fee trade for a portfolio

Raw

select-most-recent-fee-trade.sql

	SELECT id
	FROM trades
	WHERE portfolio_id = :portfolio_id
	AND type = 'fee'
	ORDER BY date DESC
	LIMIT 1;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment