Select record with MAX value in MySQL Post: 302433393

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and...

2. Shell Programming and Scripting

mysql select query optimization..

hi.. i need to optimize my select query .. my situation is like this .. i have 15 lac recors in my table.. the following query takes nine seconds to give the required output.. SELECT max(ah.AUC_AMT), SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT...

3. UNIX for Advanced & Expert Users

mysql select query optimization..

4. UNIX for Dummies Questions & Answers

Select max value based on filename

Hi, I would just like to know how to get the file with the max filename on a directory and get rid of all the others. For example, in directory A:/ i have the ff files: APPLE2001 APPLE2002 APPLE2003 GRAPE2004 what I want to get is the max in files whose filenames start with APPLE*,...

5. Shell Programming and Scripting

Max value Record from a File

I have a file with 3 columns I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them. empid,ename,Sal 1,abc,100 2,def,200 3,xyz,300 4,pqr,100 5,mnq,300 Output Any record with 300 as salary Please use next...

6. Programming

Getting Rows from a MySQL Table with max values?

I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work. Basically I wrote code like this: select * from `Test_DC_Trailer` HAVING max(DR_RefKey); Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)...

7. Shell Programming and Scripting

Select record having different value in second column

I want records which have more than one and different value in the second column on the below sample file. Ex, I have the samle file below :- XYZ 1 XYZ 3 abc 1 abc 1 qwe 2 qwe 1 qwe 3 I want to select XYZ and QWE line only.

8. Programming

MySQL select user with the same IP address

Dear community, I woul like to make a query to output all the users having the same IP address. The table is somethig like: name logged_ip ==== ========= user1 127.0.0.1 user2 127.0.0.2 user3 127.0.0.3 user4 127.0.0.1 user5 127.0.0.2 user6 127.0.0.5I used this query...

9. Shell Programming and Scripting

Script to record max memory usage of program

Hello, I am working on an application that uses allot of memory depending on the input. I am also working on more than one processing algorithm. The program has a long processing time (hours) so it would be nice to be able to monitor the maximum memory footprint of the application during runs...

LEARN ABOUT DEBIAN

asn1_parser2tree

asn1_parser2tree(3)						     libtasn1						       asn1_parser2tree(3)

NAME

       asn1_parser2tree - API function

SYNOPSIS

       #include <libtasn1.h>

       asn1_retCode asn1_parser2tree(const char * file_name, ASN1_TYPE * definitions, char * errorDescription);

ARGUMENTS

       const char * file_name
		   specify the path and the name of file that contains ASN.1 declarations.

       ASN1_TYPE * definitions
		   return the pointer to the structure created from "file_name" ASN.1 declarations.

       char * errorDescription
		   return the error description or an empty string if success.

DESCRIPTION

       Function used to start the parse algorithm.  Creates the structures needed to manage the definitions included in file_name file.

RETURNS

       ASN1_SUCCESS  if  the  file  has a correct syntax and every identifier is known, ASN1_ELEMENT_NOT_EMPTY if definitions not ASN1_TYPE_EMPTY,
       ASN1_FILE_NOT_FOUND if an error occured while opening file_name, ASN1_SYNTAX_ERROR if the syntax is not correct,  ASN1_IDENTIFIER_NOT_FOUND
       if  in  the  file  there  is  an  identifier  that is not defined, ASN1_NAME_TOO_LONG if in the file there is an identifier whith more than
       ASN1_MAX_NAME_SIZE characters.

COPYRIGHT

       Copyright (C) 2006-2011 Free Software Foundation, Inc..
       Copying and distribution of this file, with or without modification, are permitted in any medium without  royalty  provided  the  copyright
       notice and this notice are preserved.

SEE ALSO

       The  full  documentation  for libtasn1 is maintained as a Texinfo manual.  If the info and libtasn1 programs are properly installed at your
       site, the command

	      info libtasn1

       should give you access to the complete manual.

libtasn1							       2.13						       asn1_parser2tree(3)

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Discussion started by: mgirinath

2. Shell Programming and Scripting

mysql select query optimization..

Discussion started by: senkerth

3. UNIX for Advanced & Expert Users

mysql select query optimization..

Discussion started by: senkerth

4. UNIX for Dummies Questions & Answers

Select max value based on filename

Discussion started by: madden

5. Shell Programming and Scripting

Max value Record from a File

Discussion started by: traininfa

6. Programming

Getting Rows from a MySQL Table with max values?

Discussion started by: Astrocloud

7. Shell Programming and Scripting

Select record having different value in second column

Discussion started by: Sanjeev Yadav

8. Programming

MySQL select user with the same IP address

Discussion started by: Lord Spectre

9. Shell Programming and Scripting

Script to record max memory usage of program

Discussion started by: LMHmedchem

LEARN ABOUT DEBIAN

asn1_parser2tree