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 
UNION
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:

Name:
Email: (Your email is not shared with anybody)
Comment:

Facebook comments:

Site Owner: Sachin Goyal