R.Sundar
SSC Veteran
Points: 234
More actions
March 10, 2003 at 11:25 pm
#105449
Hi All
This is a strange question to my knowledge ! Consider I have table with 10 rows and I have to write a select query to return 11 rows. Any Idea.
Thanks In Advance
-Sundar
sundar R
March 13, 2003 at 8:00 am
This was removed by the editor as SPAM
JenniferS
SSC-Addicted
Points: 445
March 17, 2003 at 1:50 pm
#451262
Hello Sundar,
How about this:
Select * from tableName
Union All
Select Top 1 * from tableName
Jennifer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply