Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

SQL help plesae

Comment:

Hello helper I need help with the sql code. I need the sql to get information that is unique. For example if i have {1,2,3,4,4,5,6,6,7} in a column. the output should be {1,2,3,5,7}. now i would not know if 4,4 or 6,6 is the one that is not unique. if you don't understand please let me know. Thank you very much

Name: Michael J (by mjdamato)
Date: March 6, 2005 at 21:20:03 Pacific

Reply:

You would need to use the COUNT function. Something along the lines of SELECT "column_name" from "table_name" WHERE COUNT("column_name") = 1 Michael J

0

create simple prog

MySQL Problem

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have this series of SQL statements could someone please simple explain what each line does. I know what this does but i am not sure about how it is achieved. The SQL statements orders the table in D...

Summary: Hi, I have a simple SQL problem here. Currently I have 2 tables (A & B, let say) within my SQL database. I want to append all the records (5 fields, 10+ rows, let say) from the table A into table B, ...

Summary: i have an sql statement. SELECT empdetails.empno, empdetails.name, empdetails.store, empdetails.position, empdetails.dob, empdetails.acno, empdetails.bsb, empdetails.address, empdetails.pcode, empdeta...