Home » SQL & PL/SQL » SQL & PL/SQL » Simple format column to 5 spaces question
Simple format column to 5 spaces question [message #3435] Thu, 26 September 2002 08:09 Go to next message
Adam
Messages: 15
Registered: October 2001
Junior Member
Table = Students
Column = State

I would like assistance to write a query that will show unique states(no repeats). Format column to 5 spaces titled "State".

I also need help with a query that will return just the unique number of states. Thanks in advance..

Adam

Report message to a moderator

Re: Simple format column to 5 spaces question [message #3438 is a reply to message #3435] Thu, 26 September 2002 10:53 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select distinct state
  from students;
 
select count(distinct state)
  from students;

Report message to a moderator

Previous Topic: Concat
Next Topic: Re: Retrieving records N to N+10 !! Perplexed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 16:51:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.