I want to create a query that will select only the last "Something" from a table (in that table we mast have a date column !) (more about this here)
example:

SELECT
t.transaction_id,
t.name,
c.comment,
.
.
.
c.datecreated
FROM
transactions t
JOIN ( SELECT
transaction_id,
MAX(datecreated) as datecreated
FROM
transactioncomments
GROUP BY transaction_id ) m
ON t.transaction_id = m.transaction_id
JOIN transactioncomments c
ON t.transaction_id = c.transaction_id AND
m.datecreated = t.datecreated

Comentarii

Trimiteți un comentariu

Postări populare de pe acest blog

5Inch HDMI LCD for RPI 800x480

In order for the LCD to work ... my version Go clone from git the following git repository  LCD-show      After this, edit with your favorite text editor from console /boot/config.txt (sudo mcedit /boot/config.txt) my favorite is mc (sudo apt install mc -y) and of course, at the end of the file copy the settings from below make sure to have penirq=22 instead of penirq=25 if the touchscreen does not work   Finally for calibration if necessary do: sudo apt install -y xinput-calibrator and calibrate the screen: DISPLAY=:0.0 xinput_calibrator
Citiți mai multe

DevExpress Theme Changer ...

Original post here !  (backup purpose only) Devexpress theme changer using My.Settings to save it. 1.)Make a new form, name it whatever you would like. 2.)Reference Devexpress.BonusSkins.dll and Devexpress.OfficeSkins.dll 3.)Go to My.Settings and make a new setting with the name "Theme" with the value "Sharp" 4.)Go to your forms Designer. vb  and change the "Inherits" to DevExpress.XtraEditors.XtraForm 5.)Add 1 Button to your form and 1 ListBoxControl. Make the Text of the button "Change Theme", Make your ListBoxControl items these: Code: Caramel Money Twins Lilian The Asphalt World iMaginary Black Blue Coffee Liquid Sky London Liquid Sky Glass Oceans Stardust Xmas 2008 Blue Valentine McSkin Summer 2008 Pumpkin Dark Side Springtime Darkroom Foggy High Contrast Seven Seven Classic Sharp Sharp Plus DevExpress Style Office 2007 Blue Office 2007 Black Office 2007 Silver Office 2007 Green Office 2007 Pink Office 2010 Blue Office 2010 Black Offi
Citiți mai multe

.NET Core Dependency Injection with Func as constructor parameter

This post will be short and sweet, albeit one that caused me a bit of a headache. I recently worked on an ASP.NET Core project and I wanted to take advantage of the built-in Dependency Injection service to inject various services to the controllers. However, one of the services required a parameter in the constructor; to be more exact I was asked to create a unit of work for all the different zones that we have but the connection has to change for each region so this is the solution I came up with: The important magick is here:
Citiți mai multe