sql - Select min values for an id and for entire table in ONE query -

i want find lowest visited value specific id , lowest entire table. in 1 query.

mytab

id  visited 101 2009 102 2010 103 2011 104 2012 105 2013 

can in 1 query?

right like:

select   min(visited)   mytab   id = 100; 

and second query.

select   min(visited)   mytab; 

what want below (but can 1 make more simple?)

select    min( a.visited ),   min( b.visited )   (select visited mytab id=100) a,   (select visited mytab) b; 

---

query run e.g. id 103 , 100 be: id 103 give 2011,2009 id 100 give null,2009  

thanks

you can use min case:

select      min(case when id = 100 visited end) minbyid,     min(visited) minoverall mytab 

sql fiddle demo