PostgreSQL Exercises

Back to listing

Next Exercise

Format the names of members

Question

Output the names of all members, formatted as 'Surname, Firstname'
Schema reminder ▼
DB schema

Expected Results

name
GUEST, GUEST
Smith, Darren
Smith, Tracy
Rownam, Tim
Joplette, Janice
Butters, Gerald
Tracy, Burton
Dare, Nancy
Boothe, Tim
Stibbons, Ponder
Owen, Charles
Jones, David
Baker, Anne
Farrell, Jemima
Smith, Jack
Bader, Florence
Baker, Timothy
Pinker, David
Genting, Matthew
Mackenzie, Anna
Coplin, Joan
Sarwin, Ramnaresh
Jones, Douglas
Rumney, Henrietta
Farrell, David
Worthington-Smyth, Henry
Purview, Millicent
Tupperware, Hyacinth
Hunt, John
Crumpet, Erica
Smith, Darren

Your Answer Hint Help Save Run Query 


              

            

          

        

      

      

      

      

        

          
Answers and Discussion Show

          
select surname || ', ' || firstname as name from cd.members          

          

            

Building strings in sql is similar to other languages, with the exception of the concatenation operator: ||.  Some systems (like SQL Server) use +, but || is the SQL standard.            

          

        

      

      
      

        
Back to listing

        

          
        

        
Next Exercise

      

    

      

Use the || operator to concatenate strings
      

      

        

	  
Keyboard shortcuts:

	  
	  

	  
Other hints: