Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

Need to select only one record if max of date < today's date

0 votes
2 views
in SQL by (120 points)

Need to select only one record if max of date < today's date 

02-04-17 2017, EQP-12907

02-04-18 2018, EQP-12907

02-04-19 2019, EQP-12907

02-04-20 2020, EQP-12907

Please log in to answer this question.

Related questions

0 votes
1 answer
How to select the last record of a table in SQL?
asked Jul 29, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Fastest way to determine if record exists
asked Jul 20, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Getting only Month and Year from SQL DATE
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

...