top 5 rows without top keyword

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shikha maheshwari
    New Member
    • Nov 2006
    • 3

    top 5 rows without top keyword

    can anyone plz tell me how to fetch top 5 rows from two different tables without using the keyword top in sql with example
  • willakawill
    Top Contributor
    • Oct 2006
    • 1646

    #2
    Originally posted by shikha maheshwari
    can anyone plz tell me how to fetch top 5 rows from two different tables without using the keyword top in sql with example
    Why would you do that?

    Comment

    • sashi
      Recognized Expert Top Contributor
      • Jun 2006
      • 1749

      #3
      Originally posted by shikha maheshwari
      can anyone plz tell me how to fetch top 5 rows from two different tables without using the keyword top in sql with example
      Hi there,

      I doubt you'll be able to do that, you need to specify some kind of condition in order to get expected query result. Maybe you should use the id field or something like that. Good luck & Take care.

      Comment

      Working...