The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
The SQL MAX function syntax is very simple and it looks like this:
SELECT MAX(Column1)
FROM Table1
If we use the Customers table from our previous chapters, we can select the highest date of birth with the following SQL MAX expression:
SELECT MAX(DOB) AS MaxDOB
FROM Customers
Popular Posts
-
1 Introducing the .NET Framework with C# The .NET Framework is such a comprehensive platform that it can be a little difficult to descr...
-
SYMBOLIC CONSTANTS OR MACRO: In this #define is a macro used for a constant value to be assigned in the program. for example: pi its value i...
-
This chapter talks about installing SQL Server Express. If you have a licensed version of full SQL Server 2005, you can follow the same step... -
Dot Net Publish at Scribd or explore others: Presentations & Slid ...
-
If you expand the node "Databases" on the management studio, you will see the following sub nodes: System Databases Database Snaps... -
Introduction: In this exercise, you are going to build and run a sample Java program called Homework using NetBeans. The sample program can...
-
Introduction: In this exercise, you will exercise the concept object creation using new keyword. We will learn how you are going to create ...
-
Adding Controls to the Form There are many controls you can use with your program: Buttons, Text Boxes, Pictures, Scroll Bars and more. You ... -
Additional Command Button's Properties Add 1 Command Button to your form, and change the following properties to see what they do. Capti... -
Using functions we can structure our programs in a more modular way, accessing all the potential that structured programming can offer to us...
No comments:
Post a Comment