Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How write the ignore dupkey command in UNIX?
Top Forums Shell Programming and Scripting How write the ignore dupkey command in UNIX? Post 302820711 by doganaym on Thursday 13th of June 2013 09:31:53 AM
Old 06-13-2013
then this may help (distincts for col1 and col2):

Code:
select * from
(
select col1, col2, col3 ,row_number() over (partition by col1, col2 order by null) rn
from table1
) where rn=1;

Last edited by Scott; 06-13-2013 at 10:38 AM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

What can I ignore when backing up UNIX boxes?

Hi All, Long question and possibly a very short answer.... At work we've just got a new 3rd party backup solution (Netvault by Bakbone -it's v. nice), and I'm currently setting up my UNIX clients as part of the backup schedule. It's just occurred to me that there may be certain files or... (4 Replies)
Discussion started by: geralex
4 Replies

2. UNIX for Dummies Questions & Answers

How to ignore characters and print only number using unix?

say D45H E67H G779K F8888U T66Y Y333U output shud be like 45 67 779 8888 66 333 (5 Replies)
Discussion started by: cdfd123
5 Replies

3. Shell Programming and Scripting

Ignore the 255 character limit of command line

Hi I would just like to ask if there is a way for UNIX to ignore/overcome the 255 character limit of the command line? My problem is that I have a really long line of text from a file (300+ bytes) which i have to "echo" and process by adding commands like "sed" to the end of the line, like... (5 Replies)
Discussion started by: agentgrecko
5 Replies

4. Shell Programming and Scripting

Find command with ignore directory

Dear All, I am using find command find /my_rep/*/RKYPROOF/*/*/WDM/HOME_INT/PWD_DATA -name rk*myguidelines*.pdf -print The problem i am facing here is find /my_rep/*/ the directory after my_rep could be mice001, mice002 and mice001_PO, mice002_PO i want to ignore mice***_PO directory... (3 Replies)
Discussion started by: yadavricky
3 Replies

5. Shell Programming and Scripting

How to ignore error in command in bash script?

Hello, i have bash script where im cycling some command for different lines in external file. example: while read domain;do nslookupout=$(nslookup -type=ns $domain) || true another commands done < filenamewithdomains i added: || true after the command in belief it will just skip... (6 Replies)
Discussion started by: postcd
6 Replies

6. Shell Programming and Scripting

Grep command to ignore line starting with hyphen

Hi, I want to read a file line by line and exclude the lines that are beginning with special characters. The below code is working fine except when the line starts with hyphen (-) in the file. for TEST in `cat $FILE | grep -E -v '#|/+' | awk '{FS=":"}NF > 0{print $1}'` do . . done How... (4 Replies)
Discussion started by: Srinraj Rao
4 Replies

7. UNIX for Beginners Questions & Answers

Find command with Ignore Access issues

Hi, I am using following command to find a specific file. find . -name "find*.txt" -type f -print I am issuing that command at root directory since I don't know in which sub folder that file is getting created from some other process. As I am not having access to all directories, my... (3 Replies)
Discussion started by: RameshCh
3 Replies

8. UNIX for Beginners Questions & Answers

How to ignore Case with in COMM command?

Hi, How can i ignore case between 2 files in unix using COMM command. 2 input files are: -bash-4.1$ more x2.txt HELLO hi HI raj -bash-4.1$ more x3.txt hello hi raj COMM command: -bash-4.1$ comm x2.txt x3.txt hello HELLO hi (3 Replies)
Discussion started by: raju2016
3 Replies

9. Solaris

Solaris tar command to ignore mount points?

i.e. to stay in local filesytem. I believe the flag in linux is one-file-system. Is there corresponding in solaris? SOLARIS 9 BTW. (10 Replies)
Discussion started by: psychocandy
10 Replies

10. UNIX for Beginners Questions & Answers

UNIX command to ignore replacing a search string if it is already present

Hello, I am searching the following string Folder^ in a file and replacing it with Folder^/ However if the file already contains Folder^/ I want to avoid replacing it with Folder^// To do this I have to do the following today: 1) echo "Folder^" | sed 's/Folder\^/Folder\^\//g' I get... (2 Replies)
Discussion started by: mehimadri12
2 Replies

LEARN ABOUT DEBIAN

gtk2::treestore

Gtk2::TreeStore(3pm)					User Contributed Perl Documentation				      Gtk2::TreeStore(3pm)

NAME

       Gtk2::TreeStore - wrapper for GtkTreeStore

HIERARCHY

	 Glib::Object
	 +----Gtk2::TreeStore

INTERFACES

	 Gtk2::TreeModel
	 Gtk2::TreeDragSource
	 Gtk2::TreeDragDest
	 Gtk2::TreeSortable
	 Gtk2::Buildable

METHODS

   treestore = Gtk2::TreeStore->new (...)
       o   ... (list) of strings, package names

   treeiter = $tree_store->append ($parent)
       o   $parent (Gtk2::TreeIter or undef)

   $tree_store->clear
   $tree_store->set_column_types (...)
       o   ... (list) of strings, package names

   $tree_store->set ($iter, $col1, $val1, ...)
       o   $iter (Gtk2::TreeIter)

       o   $col1 (integer) the first column number

       o   $val1 (scalar) the first value

       o   ... (list) pairs of columns and values

   treeiter = $tree_store->insert ($parent, $position)
       o   $parent (Gtk2::TreeIter or undef)

       o   $position (integer)

   treeiter = $tree_store->insert_after ($parent, $sibling)
       o   $parent (Gtk2::TreeIter or undef)

       o   $sibling (Gtk2::TreeIter or undef)

   treeiter = $tree_store->insert_before ($parent, $sibling)
       o   $parent (Gtk2::TreeIter or undef)

       o   $sibling (Gtk2::TreeIter or undef)

   treeiter = $tree_store->insert_with_values ($parent, $position, ...)
       o   $parent (Gtk2::TreeIter or undef)

       o   $position (integer) position to insert the new row

       o   ... (list) pairs of column numbers and values

       Like doing insert followed by set, except that insert_with_values emits only the row-inserted signal, rather than row-inserted, row-
       changed, and, if the store is sorted, rows-reordered as in the multiple-operation case.	Since emitting the rows-reordered signal
       repeatedly can affect the performance of the program, insert_with_values should generally be preferred when inserting rows in a sorted tree
       store.

       Since: gtk+ 2.10

   boolean = $tree_store->is_ancestor ($iter, $descendant)
       o   $iter (Gtk2::TreeIter)

       o   $descendant (Gtk2::TreeIter)

   integer = $tree_store->iter_depth ($iter)
       o   $iter (Gtk2::TreeIter)

   boolean = $tree_store->iter_is_valid ($iter)
       o   $iter (Gtk2::TreeIter)

       Since: gtk+ 2.2

   $tree_store->move_after ($iter, $position)
       o   $iter (Gtk2::TreeIter)

       o   $position (Gtk2::TreeIter or undef)

       Since: gtk+ 2.2

   $tree_store->move_before ($iter, $position)
       o   $iter (Gtk2::TreeIter)

       o   $position (Gtk2::TreeIter or undef)

       Since: gtk+ 2.2

   treeiter = $tree_store->prepend ($parent)
       o   $parent (Gtk2::TreeIter or undef)

   boolean = $tree_store->remove ($iter)
       o   $iter (Gtk2::TreeIter)

       The return is always a boolean in the style of Gtk 2.2.x and up, even when running on Gtk 2.0.x.

   $tree_store->reorder ($parent, ...)
       o   $parent (Gtk2::TreeIter or undef)

       o   ... (list) of integer's, the new_order

       Since: gtk+ 2.2

   $tree_store->swap ($a, $b)
       o   $a (Gtk2::TreeIter)

       o   $b (Gtk2::TreeIter)

       Since: gtk+ 2.2

   $tree_store->set_value ($iter, $col1, $val1, ...)
       o   $iter (Gtk2::TreeIter)

       o   $col1 (integer) the first column number

       o   $val1 (scalar) the first value

       o   ... (list) pairs of columns and values

       Alias for Gtk2::TreeStore::set().

SEE ALSO

       Gtk2, Glib::Object

COPYRIGHT

       Copyright (C) 2003-2011 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.14.2							    2012-05-27						      Gtk2::TreeStore(3pm)
All times are GMT -4. The time now is 08:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy