Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > need sql script

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

need sql script

Reply to Message Icon

Name: siddiqa
Date: November 5, 2007 at 04:52:04 Pacific
OS: p4
CPU/Ram: 256
Comment:

I m working in Mysql database. I have loaded sum text file (contains 6000 entries and there are 3 fields )in it via the desired query, after loading i want to show the unique record of every separate field.



Sponsored Link
Ads by Google

Response Number 1
Name: Don Arnett
Date: November 6, 2007 at 11:51:31 Pacific
Reply:

"i want to show the unique record of every separate field"

I'm not clear what you mean by this.

Do you mean that for each field, you want to show all of the unique values in the table?

If so, you'd need a separate query for each field. For example:

select distinct field1
from table


This will give you the contents of field1, without displaying duplicate values.



0
Reply to Message Icon

Related Posts

See More


Installing Apache for Win... select statement help!



Post Locked

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


Go to Database Forum Home


Sponsored links
Ads by Google


Results for: need sql script
Need SQL Query www.computing.net/answers/dbase/need-sql-query/366.html

how to send sql script's spool fie to mail. www.computing.net/answers/dbase/how-to-send-sql-scripts-spool-fie-to-mail/624.html

Starting SQL www.computing.net/answers/dbase/starting-sql/71.html