Re: HELP
From: Nicolas Stern <nospam_at_hotmail.com>
Date: Fri, 3 Aug 2001 12:28:20 +0200
Message-ID: <3b6a7cc5$1_at_news.psi.ch>
Date: Fri, 3 Aug 2001 12:28:20 +0200
Message-ID: <3b6a7cc5$1_at_news.psi.ch>
- Add a column to a table alter table my_table add the_column varchar2(10);
- Average a column select avg(the_column) from the_table;
- Find the greastest value in a column select max(the_column) from the_table;
- Find the lowest value in a colum select min(the_column) from the_table;
- Put a column in date order ascending order: select * from the_table order by the_date_column;
descending order:
select * from the_table order by the_date_column desc;
Received on Fri Aug 03 2001 - 12:28:20 CEST