Results 1 to 4 of 4

Thread: (SQL)

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    undefined
    Join Date: Sep:2008
    Location: Sofia
    Posts: 214

    (SQL)

    . , SQL , , , :

    Code:
    name:
    
    
    
    
    
    
    
    
    
    
    , ? :

    Code:
    name:		=>	name:
    			
    			
    			
    			
    			
    			
    			
    			
    			
    

    GROUP BY, , . "" 1 , -.

    ? .

  2. #2
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    SELECT DISTINCT, - :

    Code:
    name:
    
    
    
    

  3. #3
    Mire-x
    Join Date: Apr:2005
    Location: Sofia
    Posts: 763
    AUTO_INCREMENT 1 ( id), , :
    Code:
    SELECT n1.name
    FROM   names AS n1
           LEFT JOIN names AS n2 ON n1.id = n2.id - 1 AND n1.name = n2.name
    WHERE  n2.id IS NULL
    (AUTO_INCREMENT ), .
    (10b) || !(10b)

  4. #4
    undefined
    Join Date: Sep:2008
    Location: Sofia
    Posts: 214
    Quote Originally Posted by Tarvin View Post
    ...
    !

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |