Make delicious recipes!

Inline Views

Inline Views can be used to create a view only during the lifetime of a query.

// Example:

with myport as //myport is an inline view here
  select port,count(*) as num from Port group by port

select port, num from myport 
select -1, count(*)+1000000000 from myport 
order by 2 desc;

Like us on Facebook to remain in touch
with the latest in technology and tutorials!

Got a thought to share or found a
bug in the code?
We'd love to hear from you:

Email: (Your email is not shared with anybody)

Facebook comments:

Site Owner: Sachin Goyal