oralce:大型数据库

oracle 10g

单表查询

select *|[distinct] colum|expression|function() [as][alias](s)]
	from table[alias](s)|dual
	[where condition(s)]
	[group by column(s)]
	[having condition(s)] 
	[order by column|number|alias|expression 
	[asc|desc] [nulls first|nulls last](s)];