SQL Help

Results 1 to 2 of 2

Thread: SQL Help

  1. #1
    Join Date
    Dec 1969

    Default SQL Help

    Why cant i run this??????<BR><BR>Select top 100 distinct(sessionid) from session<BR><BR>It tells me that i CANT USE DISTINCT IN THIS CASE<BR><BR>Any thoughts?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Help

    Don&#039t know if this will do the trick, but you could give it a try.<BR><BR>Set rowcount 100<BR>Select distinct(sessionid) from session<BR><BR><BR>Don&#039t know, just thought of it...<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts