9 Topics

Member Avatar for
Member Avatar for Magic8Computing

I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I …

Member Avatar for diafol
0
1K
Member Avatar for Szabi Zsoldos

Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of data in it. ![3bcf9a8dac9e8218c88209198e26a7e5](/attachments/small/2/3bcf9a8dac9e8218c88209198e26a7e5.png "align-left") What I want to achieve is to **STRIP** (with REGEXP?) all the strings starting with …

Member Avatar for Szabi Zsoldos
0
727
Member Avatar for red_ruewei

Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , …

Member Avatar for red_ruewei
0
458
Member Avatar for HDRG

Say I have a table like this ID -- Val1 --- Val2 1 4 5 1 7 2 1 5 9 2 9 8 2 1 2 3 9 8 3 9 5 3 7 4 3 5 7 4 7 3 5 7 9 5 4 4 How do …

Member Avatar for HDRG
0
319
Member Avatar for gbhs

Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …

Member Avatar for cgyrob
0
280
Member Avatar for paul.vanzyl.313

I need to print labels. I have people who ordered more than one book so i have to print the amount of labels equal to the amount of books they ordered. Below query. select id,name,total_copies from contacts. that's the select statement. As is it can bring back 1,john,1 2,peter,3 3,sara,2 …

Member Avatar for adam_k
0
149
Member Avatar for ford.cotterill

Hi I have the two queries below, they run far too slow around the 20 second mark , I have around 18,000 rows on the videos table and 2,000 on the other. Any thoughts? Thanks $query="SELECT videos.VIDEOID, videos.title, (select video_thumb_chosen.thumb from video_thumb_chosen where video_thumb_chosen.videoid = videos.VIDEOID group by video_thumb_chosen.thumb order …

0
124
Member Avatar for mrabrar09

Hello Everyone... Am little bit confuse whether this post is come under Jsp or MySQl... but am posting in JSP because am thinking that it jsp..not Mysql query I created one report but the report is not coming perfectly so i need your help My actual report format is like …

Member Avatar for mrabrar09
0
215
Member Avatar for PhilEaton

0 down vote favorite I am trying to write a script that will return the latest values for a unique documentid-physician-patient triplet. I need the script to act similar to a group by statement, except group by only works with one column at a time. I need to date and …

Member Avatar for PhilEaton
0
211

The End.