SQL List Entity -

in sql, there such thing list. thinking of similar table, has values cannot edited can retrieved via select statement.

something following:

a list called 'items', has following data:

• item1
• item2
• item3
• item4

when call select statement on list, 4 above values.

does such thing exist in sql?

i think might want view

(from below link)

creates virtual table contents (columns , rows) defined query. use statement create view of data in 1 or more tables in database. example, view can used following purposes:

• to focus, simplify, , customize perception each user has of database
• as security mechanism allowing users access data through view, without granting users permissions directly access underlying base tables.
• to provide backward compatible interface emulate table schema has changed

sql documentation