Why can't i retrieve data using select without a from clause?
Example:
-- Trying to retrieve a static value without using FROM clause
SELECT 'Hello, World!';
Solution:
-- Correct way to retrieve a static value in SQL
SELECT 'Hello, World!' AS greeting;
In SQL, even if you're not selecting from a table, the SELECT statement should ideally be accompanied by an alias for clarity.