Click here to Skip to main content
15,794,347 members
Home / Discussions / Database
   

Database

 
GeneralRe: Getting unique combination of rows in SQL?? Pin
Lima319-Apr-12 2:56
Lima319-Apr-12 2:56 
GeneralRe: Getting unique combination of rows in SQL?? Pin
Lima319-Apr-12 3:38
Lima319-Apr-12 3:38 
GeneralRe: Getting unique combination of rows in SQL?? Pin
Blue_Boy19-Apr-12 3:45
Blue_Boy19-Apr-12 3:45 
QuestionTraking Offence Pin
Billa218-Apr-12 21:06
Billa218-Apr-12 21:06 
AnswerRe: Traking Offence Pin
Mohibur Rashid18-Apr-12 21:45
professionalMohibur Rashid18-Apr-12 21:45 
GeneralRe: Traking Offence Pin
Billa218-Apr-12 23:09
Billa218-Apr-12 23:09 
Questioncomplicated SQL: How to filter duplicate data about technical support and compute rank Pin
bbaaking16-Apr-12 17:54
bbaaking16-Apr-12 17:54 
AnswerRe: How to filter duplicate data about technical support and compute rank Pin
TenmanS1417-Apr-12 12:00
TenmanS1417-Apr-12 12:00 
not sure about looping in MySQL, believe its tricky, so I'd take care of that in by building a recordset in your program code, first your gonna need each distinct ServiceID...

SELECT DISTINCT serviceid from service

put the results of that into an array..

then your gonna have to loop through each one with something like...

SELECT *
FROM `service`
WHERE ID
IN (

SELECT id
FROM service
WHERE serviceid = frompreviousstatement
)
ORDER BY Qos ASC
LIMIT 0 , 1

and put each result from that into another array...
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 17:41
bbaaking17-Apr-12 17:41 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
TenmanS1417-Apr-12 22:59
TenmanS1417-Apr-12 22:59 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 23:20
bbaaking17-Apr-12 23:20 
AnswerRe: How to filter duplicate data about technical support and compute rank Pin
Jörgen Andersson17-Apr-12 23:37
professionalJörgen Andersson17-Apr-12 23:37 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 23:54
bbaaking17-Apr-12 23:54 
AnswerRe: complicated SQL: How to filter duplicate data about technical support and compute rank Pin
TenmanS1418-Apr-12 12:40
TenmanS1418-Apr-12 12:40 
GeneralRe: complicated SQL: How to filter duplicate data about technical support and compute rank Pin
bbaaking18-Apr-12 22:56
bbaaking18-Apr-12 22:56 
AnswerI have solved it by myself Pin
bbaaking22-Apr-12 21:22
bbaaking22-Apr-12 21:22 
SuggestionSync data Bi-Directional Automatically- Sql Server 2008 Pin
dsrao16-Apr-12 12:49
dsrao16-Apr-12 12:49 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
kalaisw17-Apr-12 3:06
kalaisw17-Apr-12 3:06 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
dsrao17-Apr-12 7:48
dsrao17-Apr-12 7:48 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
TenmanS1419-Apr-12 5:44
TenmanS1419-Apr-12 5:44 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
JosephvObrien19-Apr-12 23:14
JosephvObrien19-Apr-12 23:14 
QuestionT-SQL Developer needed for hire. Pin
SQL Ed15-Apr-12 6:13
SQL Ed15-Apr-12 6:13 
AnswerRe: T-SQL Developer needed for hire. Pin
Mycroft Holmes15-Apr-12 14:54
professionalMycroft Holmes15-Apr-12 14:54 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 1:32
SQL Ed16-Apr-12 1:32 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 1:32
SQL Ed16-Apr-12 1:32 

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.