Can we write subquery in the SELECT clause while creating VIEWS?

Can we write subquery in the SELECT clause while creating VIEWS?

Of course. But the view will not be updateable.

1 Like