Oracle 1Z0-007: Restricting and Sorting Data

Restricting and Sorting Data

Limit the rows retrieved by a query

select last_name from person where last_name='Jeremy';

 
				select birth_date from person where year > to_date('2005-01-01','YYYY-MM-DD');


				select last_name from person where last_name like '_my%';/*ends with 'my'*/


				select last_name from person where last_name like 'Je%';/*begins with 'Je'*/


				select count(*) from book_returns

				    where to_date(expires,'YYYY-MM-DD') >= to_date(sysdate,'YYYY-MM-DD')

				    or expires is null;

Sort the rows retrieved by a query

select first_name from person where last_name='Jones' order by age;


				select last_name from person order by first_name desc;


				select last_name from person order by precio asc;/*asc is the default*/

 
				select city from state order by city, lat, long;

Updated: July 30, 2005; Joe Gakenheimer