Re: Am I crazy or is this SQL not possible

From: "Aaron Bono" <aaron(dot)bono(at)aranya(dot)com>
To: "Yasir Malik" <ymalik(at)cs(dot)stevens(dot)edu>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Am I crazy or is this SQL not possible
Date: 2006-06-01 18:38:03
Message-ID: bf05e51c0606011138t30bc43e2n79747115401de29d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> This reminds me of an interview question: I was asked how to get a
> maximum column from a table without using max. How would you do that?
>
>

Select my_column
from my_table
order by my_column desc
limit 1

--
==================================================================
Aaron Bono
President Aranya Software Technologies, Inc.
http://www.aranya.com We take care of your technology needs.
Phone: (816) 695-6071
==================================================================

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-06-01 18:39:48 Re: Am I crazy or is this SQL not possible
Previous Message maTKO 2006-06-01 18:29:01 Re: Am I crazy or is this SQL not possible