Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to filter a table by two columns
Top Forums Shell Programming and Scripting How to filter a table by two columns Post 302452188 by lColli on Thursday 9th of September 2010 01:40:36 PM
Old 09-09-2010
MySQL How to filter a table by two columns
Dear Forum,

I would like to know how could I found every result from one column at a table based at two table.

Exemplo:

Table:
Code:
Red    4
Red    5
Red    10
Black   33
Black   44
Black   5
Green  2
Green 55
Green 78

I would like to have every color with the lower result from the second column:
Code:
Red   4
Black 5
Green 2

Thank you very much!

Leandro
Last edited by Scott; 09-09-2010 at 05:19 PM.. Reason: Added code tags
 

10 More Discussions You Might Find Interesting

1. Solaris

Comparing the common columns of a table in two files

Hi, I have two text files.The first and the 2nd file have data in the same format For e.g. The first file has BOOKS COUNT: 40 BOOKS AUTHOR1 SUM:1018 MAX:47 MIN:1 AVG:25.45 BOOKS AUTHOR3 SUM:181 MAX:48 MIN:3 AVG:18.1 Note:Read it as Table columnname sum(column) max(column) min(column)... (1 Reply)
Discussion started by: ragavhere
1 Replies

2. Shell Programming and Scripting

need to insert two columns (or two feilds) at the begining of the table

Hey guys/gals, So here is what i'm starting with...its a Solaris patch diag output. bash-3.0# pca -l Using /var/tmp/patchdiag.xref from Oct/20/08 Host: seiftsx4140 (SunOS 5.10/Generic_127128-11/i386/i86pc) List: missing Patch IR CR RSB Age Synopsis ------ -- - -- --- ---... (3 Replies)
Discussion started by: zeekblack
3 Replies

3. Programming

Creating a table like format with rows and columns

I have few files which have two columns in each. like e2 1 1 2694 2 4 2485 3 2 2098 5 1 2079 6 5 2022 9 4 1734 11 5 1585 13 2 1461 18 1 1092 21 2 1019 24 1 915 25 3 907 27 1 891 28 3 890 34 1 748 39 1 700 (1 Reply)
Discussion started by: kamuju
1 Replies

4. Shell Programming and Scripting

awk filter by occurence of at least two columns

Hi, Using AWK script I want to pick those rows that has AT LEAST TWO columns EACH has a count >=3. i.e. two conditions: at least two columns, each of which has a count at least 3. There must be a simple way to do this job, but could not figure it out by myself. Input file (thousand of... (3 Replies)
Discussion started by: yifangt
3 Replies

5. Shell Programming and Scripting

Export table of 50 columns

Dear all, I have a big table of 50 columns and more then 100, 000 rows in mysql. Could you please help me that how I can export it as .csv or . txt that I can open it in MS excel????? OR how can I export the specific columns of the table??? Thanks AAWT (5 Replies)
Discussion started by: AAWT
5 Replies

6. Shell Programming and Scripting

Filter rows from table

Hi , I need to filter input file according to following All rows with the following conditions should be removed 1) If in a row, the number of 'N's starting col 2 exceeds 2 (3 or more) OR 2) If a row is duplicated with the same value, starting col 2, A value 'N' is considered missing... (1 Reply)
Discussion started by: newbie83
1 Replies

7. Shell Programming and Scripting

awk filter by columns of file csv

Hi, I would like extract some lines from file csv using awk , below the example: I have the file test.csv with in content below. FLUSSO;COD;DATA_LAV;ESITO ULL;78;17/09/2013;OL ULL;45;05/09/2013;Apertura NP;45;13/09/2013;Riallineamento ULLNP;78;17/09/2013;OL NPG;14;12/09/2013;AperturaTK... (6 Replies)
Discussion started by: giankan
6 Replies

8. UNIX for Dummies Questions & Answers

Solaris - Filter columns in text file and adding new column

Hello, I am very now to this, hope you can help, I am looking into editing a file in Solaris, with dinamic collums (lenght varies) and I need 2 things to be made, the fist is to filter the first column and third column from the file bellow file.txt, and create a new file with the 2 filtered... (8 Replies)
Discussion started by: jpbastos
8 Replies

9. Shell Programming and Scripting

Send Data to MySQL Table Columns

I have two scripts, each script reads an individual data file and copies specific lines of data and sends to MySQL table. Only difference is, each script sends data to a separate column on the same DB. I want to use one script to populate DB table and have data look horizontal, with no overlapping.... (3 Replies)
Discussion started by: SysAdminRialto
3 Replies

10. UNIX for Advanced & Expert Users

Filter table of different length

Dear Forum, I have to filter (e.g. PF=0.8) a text file according to some measured and recorded values for different fields (sensor). The files can be large and the recorded data points (ID) could differ in length. I have worked out a solution but it is very messy and not flexible. Does anybody... (4 Replies)
Discussion started by: GDC
4 Replies

LEARN ABOUT DEBIAN

ansi_cattr

term::ansi::code::attr(3tcl)					 Terminal control				      term::ansi::code::attr(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       term::ansi::code::attr - ANSI attribute sequences

SYNOPSIS

       package require Tcl  8.4

       package require term::ansi::code  ?0.1?

       package require term::ansi::code::attr  ?0.1?

       ::term::ansi::code::attr::names

       ::term::ansi::code::attr::import ?ns? ?arg...?

       ::term::ansi::code::attr::fgblack

       ::term::ansi::code::attr::fgred

       ::term::ansi::code::attr::fggreen

       ::term::ansi::code::attr::fgyellow

       ::term::ansi::code::attr::fgblue

       ::term::ansi::code::attr::fgmagenta

       ::term::ansi::code::attr::fgcyan

       ::term::ansi::code::attr::fgwhite

       ::term::ansi::code::attr::fgdefault

       ::term::ansi::code::attr::bgblack

       ::term::ansi::code::attr::bgred

       ::term::ansi::code::attr::bggreen

       ::term::ansi::code::attr::bgyellow

       ::term::ansi::code::attr::bgblue

       ::term::ansi::code::attr::bgmagenta

       ::term::ansi::code::attr::bgcyan

       ::term::ansi::code::attr::bgwhite

       ::term::ansi::code::attr::bgdefault

       ::term::ansi::code::attr::bold

       ::term::ansi::code::attr::dim

       ::term::ansi::code::attr::italic

       ::term::ansi::code::attr::underline

       ::term::ansi::code::attr::blink

       ::term::ansi::code::attr::revers

       ::term::ansi::code::attr::hidden

       ::term::ansi::code::attr::strike

       ::term::ansi::code::attr::nobold

       ::term::ansi::code::attr::noitalic

       ::term::ansi::code::attr::nounderline

       ::term::ansi::code::attr::noblink

       ::term::ansi::code::attr::norevers

       ::term::ansi::code::attr::nohidden

       ::term::ansi::code::attr::nostrike

       ::term::ansi::code::attr::reset

_________________________________________________________________

DESCRIPTION

       This package provides symbolic names for the ANSI attribute control codes. For each control code a single command is provided which returns
       this code as its result. None of the commands of this package write  to	a  channel;  that  is  handled	by  higher  level  packages,  like
       term::ansi::send.

API

   INTROSPECTION
       ::term::ansi::code::attr::names
	      This command is for introspection. It returns as its result a list containing the names of all attribute commands.

       ::term::ansi::code::attr::import ?ns? ?arg...?
	      This  command imports some or all attribute commands into the namespace ns. This is by default the namespace attr. Note that this is
	      relative namespace name, placing the imported command into a child of the current namespace. By default all commands  are  imported,
	      this can howver be restricted by listing the names of the wanted commands after the namespace argument.

   ATTRIBUTES
       ::term::ansi::code::attr::fgblack
	      Set text color to Black.

       ::term::ansi::code::attr::fgred
	      Set text color to Red.

       ::term::ansi::code::attr::fggreen
	      Set text color to Green.

       ::term::ansi::code::attr::fgyellow
	      Set text color to Yellow.

       ::term::ansi::code::attr::fgblue
	      Set text color to Blue.

       ::term::ansi::code::attr::fgmagenta
	      Set text color to Magenta.

       ::term::ansi::code::attr::fgcyan
	      Set text color to Cyan.

       ::term::ansi::code::attr::fgwhite
	      Set text color to White.

       ::term::ansi::code::attr::fgdefault
	      Set default text color (Black).

       ::term::ansi::code::attr::bgblack
	      Set background to Black.

       ::term::ansi::code::attr::bgred
	      Set background to Red.

       ::term::ansi::code::attr::bggreen
	      Set background to Green.

       ::term::ansi::code::attr::bgyellow
	      Set background to Yellow.

       ::term::ansi::code::attr::bgblue
	      Set background to Blue.

       ::term::ansi::code::attr::bgmagenta
	      Set background to Magenta.

       ::term::ansi::code::attr::bgcyan
	      Set background to Cyan.

       ::term::ansi::code::attr::bgwhite
	      Set background to White.

       ::term::ansi::code::attr::bgdefault
	      Set default background (Transparent).

       ::term::ansi::code::attr::bold
	      Bold on.

       ::term::ansi::code::attr::dim
	      Dim on.

       ::term::ansi::code::attr::italic
	      Italics on.

       ::term::ansi::code::attr::underline
	      Underscore on.

       ::term::ansi::code::attr::blink
	      Blink on.

       ::term::ansi::code::attr::revers
	      Reverse on.

       ::term::ansi::code::attr::hidden
	      Hidden on.

       ::term::ansi::code::attr::strike
	      Strike-through on.

       ::term::ansi::code::attr::nobold
	      Bold off.

       ::term::ansi::code::attr::noitalic
	      Italics off.

       ::term::ansi::code::attr::nounderline
	      Underscore off.

       ::term::ansi::code::attr::noblink
	      Blink off.

       ::term::ansi::code::attr::norevers
	      Reverse off.

       ::term::ansi::code::attr::nohidden
	      Hidden off.

       ::term::ansi::code::attr::nostrike
	      Strike-through off.

       ::term::ansi::code::attr::reset
	      Reset all attributes to their default values.

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category term of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       ansi, attribute control, color control, control, terminal

CATEGORY

       Terminal control

COPYRIGHT

       Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net>

term									0.1					      term::ansi::code::attr(3tcl)
All times are GMT -4. The time now is 08:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy