I have this table let's say Students. If there are 2 students in table and result set gives 2 rows than I want to add 5 more rows with dummy data in it no matter what it says i.e '`Dummy Record`' or something. 

```
SELECT FirstName, (SELECT COUNT(*) FROM Student) Total
FROM Student

```

If the output is like this from above query.

```
FirstName         Total
Isaac Frempong    2
Erick Ortiz       2

```

I want the output to be like this

```
FirstName         Total
Isaac Frempong    2
Erick Ortiz       2
Dummy Data        2
Dummy Data        2
Dummy Data        2
Dummy Data        2
Dummy Data        2

```

I hope it's achievable, I'm unable to figure how to apply CASE or IF statements here. Maybe somebody could help.