Click here to Skip to main content
12,073,325 members (72,554 online)
   

Database

 
QuestionIssues installing ODP.NETx64 Pin
cpp_prgmer6-Dec-12 5:18
membercpp_prgmer6-Dec-12 5:18 
AnswerRe: Issues installing ODP.NETx64 Pin
Eddy Vluggen6-Dec-12 15:37
memberEddy Vluggen6-Dec-12 15:37 
GeneralRe: Issues installing ODP.NETx64 Pin
Peter_in_27806-Dec-12 16:12
memberPeter_in_27806-Dec-12 16:12 
GeneralRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 17:52
memberMycroft Holmes6-Dec-12 17:52 
AnswerRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 17:53
memberMycroft Holmes6-Dec-12 17:53 
QuestionSQL Query - append results Pin
AndreFratelli5-Dec-12 7:43
memberAndreFratelli5-Dec-12 7:43 
AnswerRe: SQL Query - append results Pin
Chris Meech5-Dec-12 7:55
memberChris Meech5-Dec-12 7:55 
GeneralRe: SQL Query - append results Pin
AndreFratelli5-Dec-12 8:08
memberAndreFratelli5-Dec-12 8:08 
QuestionSQL 2008 Data Base Table Design suggestion Pin
VishwaKL5-Dec-12 0:36
memberVishwaKL5-Dec-12 0:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale5-Dec-12 0:43
memberSimon_Whale5-Dec-12 0:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
VishwaKL5-Dec-12 0:47
memberVishwaKL5-Dec-12 0:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale5-Dec-12 0:51
memberSimon_Whale5-Dec-12 0:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
PIEBALDconsult5-Dec-12 4:56
memberPIEBALDconsult5-Dec-12 4:56 
Question[HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 21:14
memberjimmy.suharry4-Dec-12 21:14 
I've some data, there are
RealData Balance 	 Sort by Desc
A  684 	 345 		 A  684 
B  60 	 -   		 E  308 
C  -   	 -   		 J  302 
D  -   	 -   		 I  273 
E  308 	 - 		 O  178 
F  -   	 -   		 H  140 
G  11 	 -   		 B  60 
H  140 	 - 		 N  27 
I  273 	 - 		 Q  22 
J  302 	 -   		 R  20 
K  -   	 -   		 P  14 
L  -   	 -   		 G  11 
M  -   	 -   		 C  -   
N  27 	 -   		 D  -   
O  178 	 38 		 F  -   
P  14 	 -   		 K  -   
Q  22 	 -   		 L  -   
R  20 	 4   		 M  -   
 
Description
Proc = Process
Res = Result
Sort by Desc
 
Get 8 row data 														
Proc 1  Res 1 	Proc 2  Res 2 	Proc 3 	 Res 3 	 Proc 4  Res 4 	 Finish for 8 row data
A  684  657 	A  657  635 	A  635 	 621 	 A  621  610 	 A  610  	
E  308  281 	E  281  259 	E  259 	 245 	 E  245  234 	 E  234 	
J  302  275 	J  275  253 	J  253 	 239 	 J  239  228 	 J  228 	
I  273  246 	I  246  224 	I  224 	 210 	 I  210  199 	 I  199 	
O  178  151 	O  151  129 	O  129 	 115 	 O  115  104 	 O  104 	
H  140  113 	H  113  91 	H  91 	 77 	 H  77 	 66 	 H  66 	
B  60 	 33 	B  33 	11 	R  20 	 6 	 B  11 	 -   	 R  6 	
N  27 	 -   	Q  22 	-   	P  14 	 -   	 G  11 	 -   	 B  -   	
Q  22 	 22 	R  20 	20 	B  11 	 11 	 R  6 	 6 	 G  -   	
R  20 	 20 	P  14 	14 	G  11 	 11 	 P  -    -   	 P  -   	
P  14 	 14 	G  11 	11 	Q  -   	 -   	 Q  -    -   	 Q  -   	
G  11 	 11 	N  -    -   	N  -   	 -   	 N  -    -   	 N  -   	
C  -    -   	C  -    -   	C  -   	 -   	 C  -    -   	 C  -   	
D  -    -   	D  -    -   	D  -   	 -   	 D  -    -   	 D  -   	
F  -    -   	F  -    -   	F  -   	 -   	 F  -    -   	 F  -   	
K  -    -   	K  -    -   	K  -   	 -   	 K  -    -   	 K  -   	
L  -    -   	L  -    -   	L  -   	 -   	 L  -    -   	 L  -   	
M  -    -   	M  -    -   	M  -   	 -   	 M  -    -   	 M  -   	
 
Result 	 1 	 27 
Result 	 2 	 22 
Result 	 3 	 14 
Result 	 4 	 11 
 
Total 1		 74 (For 8 row data)
 

 
Get 4 row data 														
Proc 1 	 Res 1 	 Proc 2  Res 2 	 Proc 3  Res 3 	 Finish for 4 row data
A  610 	 411 	 A  411  376 	 A  376  347 	 A  347  345 
E  234 	 35 	 O  104  69 	 O  69 	 40 	 O  40 	 38 
J  228 	 29 	 H  66 	 31 	 H  31 	 2 	 R  6 	 4 
I  199 	 -   	 E  35 	 -   	 J  29 	 -   	 H  2 	 -   
O  104 	 104 	 J  29 	 29 	 R  6 	 6 	 J  -    -   
H  66 	 66 	 R  6 	 6 	 E  -    -   	 E  -    -   
R  6 	 6 	 I  -    -   	 I  -    -   	 I  -    -   
B  -   	 -   	 B  -    -   	 B  -    -   	 B  -    -   
G  -   	 -   	 G  -    -   	 G  -    -   	 G  -    -   
P  -   	 -   	 P  -    -   	 P  -    -   	 P  -    -   
Q  -   	 -   	 Q  -    -   	 Q  -    -   	 Q  -    -   
N  -   	 -   	 N  -    -   	 N  -    -   	 N  -    -   
C  -   	 -   	 C  -    -   	 C  -    -   	 C  -    -   
D  -   	 -   	 D  -    -   	 D  -    -   	 D  -    -   
F  -   	 -   	 F  -    -   	 F  -    -   	 F  -    -   
K  -   	 -   	 K  -    -   	 K  -    -   	 K  -    -   
L  -   	 -   	 L  -    -   	 L  -    -   	 L  -    -   
M  -   	 -   	 M  -    -   	 M  -    -   	 M  -    -   
 
Result 	 1 	 199 
Result 	 2 	 35 
Result 	 3 	 29 
Result 	 4 	 2 
		
Total 2 	 265 (For 4 row data)

How to get this data using Query or Function? And how to using in PHP?
Please help!

Thank you.
Jimmy

modified 5-Dec-12 2:24am.

AnswerRe: [HELP] how to using array in my case? (Query & PHP) Pin
Mycroft Holmes4-Dec-12 21:38
memberMycroft Holmes4-Dec-12 21:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 21:56
memberjimmy.suharry4-Dec-12 21:56 
QuestionSQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 4:09
memberAnirbanM 23-Dec-12 4:09 
AnswerRe: SQL query Date Sort Problem Pin
ihoecken3-Dec-12 5:42
memberihoecken3-Dec-12 5:42 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:46
memberAnirbanM 23-Dec-12 19:46 
AnswerRe: SQL query Date Sort Problem Pin
Eddy Vluggen3-Dec-12 6:20
memberEddy Vluggen3-Dec-12 6:20 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:48
memberAnirbanM 23-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 0:00
memberEddy Vluggen4-Dec-12 0:00 
AnswerRe: SQL query Date Sort Problem Pin
djj553-Dec-12 6:46
memberdjj553-Dec-12 6:46 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 20:12
memberAnirbanM 23-Dec-12 20:12 
AnswerRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 9:50
memberPIEBALDconsult3-Dec-12 9:50 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 14:12
memberMycroft Holmes3-Dec-12 14:12 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 14:18
memberPIEBALDconsult3-Dec-12 14:18 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 17:18
memberMycroft Holmes3-Dec-12 17:18 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 18:29
memberPIEBALDconsult3-Dec-12 18:29 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:57
memberAnirbanM 23-Dec-12 19:57 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:52
memberAnirbanM 23-Dec-12 19:52 
AnswerRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 17:24
memberMycroft Holmes3-Dec-12 17:24 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 18:28
memberPIEBALDconsult3-Dec-12 18:28 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 20:07
memberAnirbanM 23-Dec-12 20:07 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 20:10
memberAnirbanM 23-Dec-12 20:10 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 20:48
memberMycroft Holmes3-Dec-12 20:48 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 3:12
memberAnirbanM 24-Dec-12 3:12 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 3:30
memberAnirbanM 24-Dec-12 3:30 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 4:12
memberEddy Vluggen4-Dec-12 4:12 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 4:27
memberAnirbanM 24-Dec-12 4:27 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 5:44
memberEddy Vluggen4-Dec-12 5:44 
AnswerRe: SQL query Date Sort Problem Pin
Michael Potter4-Dec-12 9:11
memberMichael Potter4-Dec-12 9:11 
AnswerRe: SQL query Date Sort Problem Pin
jschell4-Dec-12 9:23
memberjschell4-Dec-12 9:23 
Questionoltp vs olap Pin
a.fatemeh2-Dec-12 11:51
membera.fatemeh2-Dec-12 11:51 
AnswerRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 12:49
memberMycroft Holmes2-Dec-12 12:49 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 12:57
membera.fatemeh2-Dec-12 12:57 
GeneralRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 14:28
memberMycroft Holmes2-Dec-12 14:28 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 14:41
membera.fatemeh2-Dec-12 14:41 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 11:32
memberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group Pin
Mycroft Holmes2-Dec-12 12:43
memberMycroft Holmes2-Dec-12 12:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.160208.1 | Last Updated 10 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid