Select Query

• 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

  
  sundar R

• March 13, 2003 at 8:00 am

  This was removed by the editor as SPAM

• JenniferS

  SSC-Addicted

  Points: 445

  More actions

  March 17, 2003 at 1:50 pm

  #451262

  Hello Sundar,

  How about this:

  Select * from tableName

  Union All

  Select Top 1 * from tableName

  Jennifer