+ Reply to Thread
Results 1 to 3 of 3

Thread: sqlplus

  1. 02-03-2001 07:43 AM #1
    pras
    pras is offline Member
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    hi everybody
    what is the difference btw distinct and unique in sqlplus
    thanks in advance.
    pras
    Reply With Quote Reply With Quote
  2. 02-03-2001 10:42 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    these two keywords are synonymous I guess.
    Reply With Quote Reply With Quote
  3. 02-04-2001 05:07 PM #3
    akkerend's Avatar
    akkerend
    akkerend is offline Senior Member
    Join Date
    Jul 2000
    Posts
    296
    In a SELECT statement they are synonym:
    SELECT DISTICT job FROM EMP;
    SELECT UNIQUE job FROM EMP;

    But only in a select statement, you dont have distinct indexes.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width