OrientDB: Filter select on super class

Question

Using the OrientDB console there is a command to show all records with a class that extends a base class.

browse class Asset

This returns all records that have a class (Object1, Object2) that extends Asset.

I'm looking for a SQL command that can do the same.

Currently this query does not return the same set of records.

SELECT * V where @class = 'Asset'

Answer 1

To retrieve all the records from Object1 and Object2, a simple select query from the superclass name should work :

select from Asset