Skip to Content
0
Former Member
Dec 20, 2006 at 01:22 PM

max in select statement

27 Views

Hi,

I need to get the maximum number for a fiekld from a table...

like

I have a table as ZType

in that i have fields as

Empid Name

1 S

2 V

3 A

I need the maximum of the empid...

That is 3...

How to do this in select statement.