About
Pricing
Community
Teams
Start Free Trial
Log in
Brian
asked on
12/21/2012
Show Last 5 Closed Tickets
Hello Experts,
I have the following table with the values listed below. I need to display the Last 5 Closed Tickets based on the value "tkt_cmpl_dt" which has a DateTime that the ticket was closed.
Tickets Table:
tkt_id int PK
tkt_cmpl_dt DateTime
Microsoft SQL Server
SQL
2
1
Last Comment
brendonfeeley
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Steve Wales
12/21/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
brendonfeeley
12/21/2012
Maybe something along the lines of:
SELECT TOP 5 * FROM tickets_table ORDER BY tkt_cmpl_dt DESC;
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SELECT TOP 5 * FROM tickets_table ORDER BY tkt_cmpl_dt DESC;