11-13-2007
Quote:
Originally Posted by
kahuna
So, without order by, the same query executed twice could, theoretically, return the same records in two totally different orders.
True. Even if the files are not ordered it would be possible to pipe them through "sort" (man sort) to get them sorted prior to searching them. This would limit the search-effort too, because at some point one could be sure that no matching record will follow.
bakunin
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am very new to Unix. What are the similiarities and differences between ScoUnix and AIX5 if any? Where might i find the information? Which is better? (1 Reply)
Discussion started by: NewGuy100
1 Replies
2. Shell Programming and Scripting
Kindly help on follows.
I have 2 files. One file contains only one column of mobile numbers. And total records in a file 12 million. Second file contains 2 columns mobile numbers and balance. and total records 30 million. I want to find out balance of each data in file 1 corresponding to file 2.... (2 Replies)
Discussion started by: kamal_418
2 Replies
3. Shell Programming and Scripting
Hi,
I have a problem with comparison of two files
file1
20100101
20090101
20080101
20071001
20121229
file2
19990112 12 456 7
20011131 19
20100101 2 567 1 987
17890709 123 555
and, sh script needs to compare of these two files and give out to me result:
20100101 2 567 1 987
it... (5 Replies)
Discussion started by: shizik
5 Replies
4. Shell Programming and Scripting
Hello,
I have 2 files and I want them to be compared in a specific fashion
file1:
A_1200_1250
A_1251_1300
B_1301_1350
B_1351_1400
B_1401_1450
C_1451_1500 and so on...
file2:
1210 1305 1260 1295
1400 1500 1450 1495
Now The script should look for "1200" from A_1200_1250 of... (8 Replies)
Discussion started by: Diya123
8 Replies
5. Shell Programming and Scripting
Hi all
I have two files which I have to compare that whetehr there is soemthing common or not
body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; }
body, div, table, thead, tbody, tfoot,... (2 Replies)
Discussion started by: manigrover
2 Replies
6. Shell Programming and Scripting
Hi all,
I want to compare two files with same number of rows and columns with records in same order.
Just want to highlight the differences in the column values if any.
file A
1,kolkata,19,ab
2,delhi,89,cd
3,bangalore,56,ef
file2:
1,kolkata,21,ab
2,mumbai,89,gh
3,bangalore,11,kl... (9 Replies)
Discussion started by: prabhat.diwaker
9 Replies
7. Shell Programming and Scripting
Hi All ,
As I am new to unix scripting ,I need a help regarding unix scripting .I have two .txt files .One is source file and another is target file.I need a script through which I can compare those two files.I need a automated comparison report in a directory after comparing between source &... (2 Replies)
Discussion started by: STCET22
2 Replies
8. Shell Programming and Scripting
Hi All ,
I am aware of unix command ,but not comforable in putting together in script level.I came to situation where I need to compare between two .txt files fieldwise and need a mismatch report. As I am new to unix script arena ,if anyone can help in the below scenario that will be really... (9 Replies)
Discussion started by: STCET22
9 Replies
9. Shell Programming and Scripting
I have two files which has component name and version number separated by a space
cat file1
com.acc.invm:FNS_PROD 94.0.5
com.acc.invm:FNS_TEST_DCCC_Mangment 94.1.6
com.acc.invm:FNS_APIPlat_BDMap 100.0.9
com.acc.invm:SendEmail 29.6.113
com.acc.invm:SendSms 12.23.65
cat file2 ... (8 Replies)
Discussion started by: rakeshtomar82
8 Replies
10. Shell Programming and Scripting
I have the requirement
I have two files
cat fileA
something
anythg
nothing
everythg
cat fileB
everythg
anythg
Now i shld use fileB and compare every line at fileA and get the output as
something
nothing (3 Replies)
Discussion started by: Priya Amaresh
3 Replies
LEARN ABOUT DEBIAN
axi-cache
AXI-CACHE(1) User Commands AXI-CACHE(1)
NAME
axi-cache - query the Apt Xapian Index
SYNOPSIS
axi-cache [options] command [args]
DESCRIPTION
Query the Apt Xapian index.
Commands:
search commands:
axi-cache again [query]
repeat the last search, possibly adding query terms
axi-cache help
show a summary of commands
axi-cache info
print information about the apt-xapian-index environment
axi-cache last [count]
show the last results again
axi-cache more [count]
show more terms from the last search
axi-cache rdetails pkgname[s]
show details of reverse relationships for the given packages
axi-cache search [terms]
start a new search
apt-cache front-ends:
axi-cache depends pkgname[s]
run apt-cache depends pkgname[s]
axi-cache madison pkgname[s]
run apt-cache madison pkgname[s]
axi-cache policy pkgname[s]
run apt-cache policy pkgname[s]
axi-cache rdepends pkgname[s]
run apt-cache rdepends pkgname[s]
axi-cache show pkgname[s]
run apt-cache show pkgname[s]
axi-cache showpkg pkgname[s]
run apt-cache showpkg pkgname[s]
axi-cache showsrc pkgname[s]
run apt-cache showsrc pkgname[s]
OPTIONS
--version
show program's version number and exit
-h, --help
show this help message and exit
-s SORT, --sort=SORT
sort by the given value, as listed in /var/lib/apt-xapian-index/values. Add a '-' to reverse sort order
--tags show matching tags, rather than packages
--tabcomplete=TYPE
suggest words for tab completion of the current command line (type is 'plain' or 'partial')
--last use 'show --last' to limit tab completion to only the packages from the last search results
--all disable pagination and always show all results. Note that search results are normally sorted by relevance, so you may find meaning-
less results at the end of the output
axi-cache 0.45 December 2011 AXI-CACHE(1)