sql question

Soumi Chakraborty
Soumi Chakraborty used Ask the Experts™
on
If a table has a list of multiple foreclosure codes, and you don’t know how much unique codes are in the table, how could you get a list of unique codes within the table.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Select distinct foreclosure from <TableName>

here foreclosuere is the column name and tablename is the table name.

Author

Commented:
Thank  u

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial