Search Results

Search found 3047 results on 122 pages for 'subset sum'.

Page 65/122 | < Previous Page | 61 62 63 64 65 66 67 68 69 70 71 72  | Next Page >

• select query related problem

  - by user222585

  i have interest rate and amount in a table where interest rate are ranged in different values like 4.5,4.6,5.2,5.6 etc. i want to get sum of amounts classified by interest rate where interest rate will be separated by .25. for example all amount having interest rate 1.25,1.3,1.4 will be in one group and 1.5,1.67,1.9 will be in another group how can i write the query?

  Read the article

• Order a foreach, by the value of a calculation of values in the array

  - by Mark

  I have an array as follows: $players = array( $player = array( 'name' => 'playername', 'speed' => '10', 'agility' => '10', 'influence' => '10' ) etc Then I calculate a $score, based on the sum of speed, agility and influence. $score = $p['speed'] + $p['agility'] + $p['influence']; How can I loop through my array, but order the results from highest to lowest $score? PS- http://pastebin.com/eUEQ5y4u

  Read the article

• What is the result of this SQL query?

  - by Martin

  I'm working on a mock exam paper at the moment, however I have no set of correct answers and I'm not sure what the correct answer of this SQL query is. Given a table: foo, bar a , 1 b , 3 a , 2 c , 1 and the query: SELECT foo, sum(bar) FROM table GROUP BY foo The two ways I can see this going are either: a 3 a 3 b 3 c 1 or a 3 b 3 c 1 Thanks.

  Read the article

• convert to UDF from select statement

  - by jeff

  How would one go about converting this into a UDF? I'll pass the product_id to the UDF. Running SQL 2k5 SELECT sum(qty) as qty, product_id FROM vProductQuantity WHERE product_id = @product_id GROUP BY product_id

  Read the article

• MYSQL Query using subquery

  - by Michael Quiles

  Cant get this to work can any one help. List the part number, part description, and on_hand value of each part whose number of units on hand is more than the average number of units onhand for all parts use a subquery? SELECT PART_NUM, DESCRIPTION, SUM(ON_HAND * PRICE) ON_HAND_VALUE FROM PART; WHERE MAX(ON_HAND); (AVG(ON_HAND) > ON_HAND);

  Read the article

• Does F# have an equivalent to Haskell's take?

  - by McMuttons

  In Haskell, there is a function "take n list" which returns the first n elements from a list. For example "sum (take 3 xs)" sums up the first three elements in the list xs. Does F# have an equivalent? I expected it to be one of the List-functions, but I can't spot anything that seems to match.

  Read the article

• need help while working on a website

  - by EqEdi

  I'm working for a website where i need to sum functionality related to sales I'm very new to the website stuff and found many things on net but don't knew what to follow. Can anybody suggest me some good tutorials which i can follow to create my website The things which i am going to work on as: saving customer information to data base using saved customer information, placing order generating bills and invoices and downloading it in pdf file format sending mails to customer with those invoice as attachments

  Read the article

• strip () and get value

  - by mandnd

  I have a html list that looks like this: animals (45) houses (36) computers (96) I want to get all the values inside those () and make like $sum = 45+36+96; How can I do that? Thanks

  Read the article

• Weighted random numbers in MATLAB

  - by yuk

  How to randomly pick up N numbers from a vector a with weight assigned to each number? Let's say: a = 1:3; % possible numbers weight = [0.3 0.1 0.2]; % corresponding weights In this case probability to pick up 1 should be 3 times higher than to pick up 2. Sum of all weights can be anything.

  Read the article

• summing two colums total in mysql

  - by JPro

  I want a resultset for this table : ID Number_of_posts Number_of_user 1 100 21 2 23 34 as ID Number_of_posts Number_of_user Number_of_posts_AND_Number_of_user 1 100 21 178 2 23 34 178 ----------------------------------------------- 123 55 Is it possible to get the sum of two colums as another column/ as output in mysql?

  Read the article

• HOW TO RETURN VALUE FROM FUNCTION? (c#)

  - by Ole Jak

  So... I want to return value when C# function is called. I need a code example (simple summ of a,b values will be ok) Please help I need something like this ( I know ActionScript so I will write in it): public function sum(valueA:int, valueB:int):int { var summ:int = valueA + valueB; return summ; } How to translate it into C#?

  Read the article

• How to define a history chart in crystal reports .net (2008)?

  - by hp

  Hi, I want to display a Bar Chart in a Report that shows the sum of a measure grouped by month for the last 24 month. The months that do not have any tuples do not show up in the graph. I do not want that. I want exactly 24 groups/bars that are 0 if there are no tuples. What is the best way to do this? thanks

  Read the article

• percentage formula in crystal report 8.5

  - by sathik

  am doing one project using vb6.0+access+crystal report8.5 some error occur during the crystal report. Query Name seqquery: SELECT segment_trans.division_name, sum(segment_trans.Total_value) AS total, division_master.Target FROM segment_trans, division_master GROUP BY segment_trans.division_name, division_master.Target; crystal report percentage formula: {(seqquery.total * 100) / seqquery.Target } Error: This field name is not known. note: Total_value and Target field's datatype "Text" how to solve this ? please help me. Thanks Sathik

  Read the article

• LINQ to SQL selecting fields

  - by user3686904

  I am trying to populate more columns in the query below, could someone assist me? QUERY: var query = from r in SQLresults.AsEnumerable() group r by r.Field<string>("COLUMN_ONE") into groupedTable select new { c1 = groupedTable.Key, c2 = groupedTable.Sum(s => s.Field<decimal>("COLUMN_TWO")), }; How could I get a column named COLUMN_THREE in this query ? Thanks in advance

  Read the article

• Need help Linq query join + count + group by

  - by user233540

  I have two table First table BID Town 1 ABC 2 ABC2 3 ABC Second Table PID BID AmountFirst AmountSecond AmountThird Minority 1__ 1___ 1000_____ 1000________ 1000_____ SC 2__ 2___ 2000_____ 1000_______ 2000_____ ST 3__ 3___ 1000____ 1000_______ 1000_______ SC BID is foreign key in Second table. I want sum AmountFirst + AmountSecond +AmountThird for individualTown e.g for ABC town answer should be : 6000 (summation of PID 1 and PID 2) I want Linq query for this..Please help

  Read the article

• How to return value from function? (translate actionscript to c#)

  - by Ole Jak

  So... I want to return value when C# function is called. I need a code example (simple summ of a,b values will be ok) Please help I need something like this ( I know ActionScript so I will write in it): public function sum(valueA:int, valueB:int):int { var summ:int = valueA + valueB; return summ; } How to translate it into C#?

  Read the article

• Which directories does PHP check when including a relative path with include() ?

  - by user198729

  It's very odd,has anyone ever sum up with a conclusion yet? Sometimes it checks the directory of the included file,too. But sometimes not.

  Read the article

• What are :+ and &+ in ruby?

  - by Valentin Vasilyev

  I've seen these several times but I can't figure out how to use them. The pickaxe says that these are special shortcuts but I wasn't able to find the syntactical description. I've seen them in such contexts: [1,2,3].inject(:+) to calculate sum for example.

  Read the article

• check if a value is NULL or Less than 0 in one TSQL statement

  - by Name.IsNullOrEmpty

  ISNULL(SUM(MyTable.Total), 0) AS Total how can i modify the above statement to also check if Total is less than 0 (zero), such that if Total is NULL or less than 0 (negative), i assign 0 to Total

  Read the article

• Count of Sums possibly using group_by

  - by Daniel Johnson

  Say you have a user table and an order table which references user (user has_many orders) and contains an item count field. How could you efficiently ask "how many uses ordered how many items?" That is, to generate something along the lines of: Number of users | sum of items ------------------------------- 5 users | 1 item 4 users | 5 items 1 user | 7 items Thanks in advance.

  Read the article

• Problem with python !!

  - by the-ifl

  Well I Have a little problem , i want to Get the sum of all numbers below to 1000000 , and who has 4 Divisors... I Try but i have a problem : http://pastebin.com/bhiDb5fe

  Read the article

• Is there a function for checking whether a matrix is diagonally dominant (row dominance)

  - by ldigas

  A matrix is diagonally dominant (by rows) if its value at the diagonal is greater then the sum of all absolute value in that row. Same goes for columns, only the other way around. Is there a function in matlab for chekcing this ? (I could write a simple loop, but I'm trying to quit those).

  Read the article

• How Can I Implement This Function?

  - by hoora

  I'm a beginner and I want to write Java code in eclipse. This program takes two LinkedLists of integers (for example, a and b) and makes a LinkedList (for example d) in which every element is the sum of elements from a and b. However, I can't add these two elements from a and b because they are Objects Example: a=[3,4,6,7,8] b=[4,3,7,5,3,2,1] ------ d=[7,7,13,12,11,2,1]

  Read the article

• Problem with a Python function

  - by the-ifl

  Well I have a little problem. I want to get the sum of all numbers below to 1000000, and who has 4 divisors... I try, but i have a problem because the GetTheSum(n) function always returns the number "6"... This is my Code : http://pastebin.com/bhiDb5fe

  Read the article

• c programming Language [closed]

  - by ash89

  Write a program in C program to find the sum of the following: The input contain a sequence of two or more positive integers terminated by -1. Write a piece of code to count the ‘incidences’ in this sequence (i.e. the number of pairs of equal, adjacent numbers). For example, the following sequence contains 4 incidences: 4 2 9 9 3 7 7 7 3 3 -1

  Read the article

< Previous Page | 61 62 63 64 65 66 67 68 69 70 71 72  | Next Page >