Select Dummy Data SQL Return fake row

Select Dummy Data SQL Return fake row

If you want to return dummy data without using table with multiple rows you could use below query:

SELECT 'Test1' as DummyData
    UNION SELECT 'Test2'
    UNION SELECT 'Test3'

• Result:

• Another query to return dummy data in single row:

SELECT 'Test1', 'Test2', 'Test3'

• Result: