Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
group_concat
- Page 1
Re: Mastodon
Community Center
Geeks' Lounge
1 Day Ago
by Dani
I just stumbled upon this and had no idea that Mastodon was even a thing 6 years ago, pty! I first became aware of them back when Elon bought Twitter (ahem, X) and everyone fled ship trying to find an alternative. Sorry no one replied to this thread until now. Guess you were just too ahead of your time. ;)
Claude 3 Opus Vs. Google Gemini Vs. GPT-4 for Zero-Shot Text Classification
Programming
Computer Science
1 Week Ago
by usmanmalik57
On March 4, 2024, [Anthropic](https://www.anthropic.com/) launched the [Claude 3 family of large language models](https://www.anthropic.com/news/claude-3-family). Anthropic claimed that its Claude 3 Opus model outperforms GPT-4 on various benchmarks. Intrigued by Anthropic's claim, I performed a simple test to compare the performances of Claude …
The Rise of AI Scams: Deciphering Reality in a World of Deepfakes
Community Center
4 Weeks Ago
by Johannes C.
**Discover the world of AI scams and find out how you can shield yourself against the cunning deceptions of deepfakes.** ![deepfakes-deep-implications.jpg](https://static.daniweb.com/attachments/4/782a49e1fa4e86bd0bedf3957bec4df9.jpg) In an incident that underscores the alarming capabilities of artificial intelligence in the realm of fraud, a…
Re: Improve HAVING BY performance
Programming
Databases
2 Weeks Ago
by Reverend Jim
I'm not very familiar with HAVING but my understanding is that it is used to filter results after a GROUP operation so I can't imagine that indexes would improve performance other than on the original SELECT. Using WHERE would return rows based on one or more criteria, and would benefit from indexing, but HAVING, as I understand, is performed after…
Re: 88 Business-Growing Strategies
Digital Media
Digital Marketing
1 Week Ago
by henrymorgan9522
A growth strategy is an organization's plan for overcoming current and future challenges to realize its goals for expansion. Examples of growth strategy goals include increasing market share and revenue, acquiring assets, and improving the organization's products or services.
Multivariate Stock Price Prediction with Transformer Encoder in TensorFlow
Programming
Computer Science
2 Months Ago
by usmanmalik57
In a [previous tutorial](https://www.daniweb.com/programming/computer-science/tutorials/541123/stock-price-prediction-using-1d-cnn-in-tensorflow-keras), I covered how to predict future stock prices using a deep learning model with 1D CNN layers. This method is effective for basic time series forecasting. Recently, I've enhanced this model by not…
TensorFlow Keras Sequence Data Generator for Multimodal Classification
Programming
Computer Science
2 Months Ago
by usmanmalik57
I recently tackled a challenging research task involving multimodal data for a classification problem using [TensorFlow Keras](https://www.tensorflow.org/guide/keras). One of the trickiest aspects was figuring out how to load multimodal data in batches from storage efficiently. While TensorFlow Keras offers helpful functions for batch-loading …
Trump Returns & A Good Year for BTC: ChatGPT’s Bold Predictions for 2024
Community Center
2 Months Ago
by Johannes C.
**Who will win an Oscar? Who will be president? When will GPT-5 be released? And will humanity achieve AGI in 2024? Here are ChatGPT's 10 wildest speculations for the new year. ** ![nostradamus-chatgpt.jpg](https://static.daniweb.com/attachments/4/ba0b52e08c3a8a560278083de1d5aa38.jpg) "As a Large Language Model, I am not programmed to …
Re: What is most effective social media platform for paid campaign?
Digital Media
Digital Marketing
1 Month Ago
by trueframe
Deciding which social media platform is most effective for your paid campaign depends on several factors, including your target audience, campaign goals, and type of business or product. Each platform has its strengths, and the effectiveness of your campaign will largely depend on where your target audience is most active. Here's a quick overview …
Re: What is most effective social media platform for paid campaign?
Digital Media
Digital Marketing
1 Month Ago
by cat_127
Instagram: Pros: Instagram is highly visual, making it perfect for brands with visually appealing products and services. It is suitable for industries such as fashion, beauty, travel, and lifestyle, as it has a large young user group. Instagram is seamlessly integrated into his Facebook Ads Manager. LinkedIn: Strengths: LinkedIn is a …
Re: Design vs. Coding
Programming
Software Development
1 Month Ago
by Reverend Jim
I frequently had to deal with Engineers who felt they could both design software and write it. I only once met an engineer who could do both competently. She got her degree in computer engineering and started in my group as a junior member. She rose quickly through the ranks and even became my boss for a couple of years (my happiest at work) before…
Re: Design vs. Coding
Programming
Software Development
1 Month Ago
by chuckc
Reading this I thought, suppose in a group of cave men, some were good at making wheels and some were very good at making wagons. If they switched rolls might they get round wagons with square wheels? On the other hand, if they had a wheel maker who insisted on making square wheels, switching roles might be a good thing. Maybe one size doesn’t …
Re: Why am getting different syntax errors when running a Python script
Programming
Software Development
1 Month Ago
by Tom_45
After I posted this question I noticed that I was missing the raw string indicator and the capture group enclosing parenthesis on the findall, which explains the subscripting error. So, hold off on the answers for now. I'm still having other issues with multiple file runs, though.
Re: JTABLE HEADER GROUP
Programming
Software Development
2 Months Ago
by Jan_315
Hi, I have the same problem. Do you already know the solution? Thanks
Re: JTABLE HEADER GROUP
Programming
Software Development
2 Months Ago
by Jan_315
I have found it. These lines are necessary: private JTable table = new JTable( dm ) { protected JTableHeader createDefaultTableHeader() { return new EtsGroupableTableHeader(columnModel); } };
Re: Trump Returns & A Good Year for BTC: ChatGPT’s Bold Predictions for 2024
Community Center
2 Months Ago
by carriejo810
I did the same for Bard: Who will Win the 2024 US Presidential Election? Answer: In a surprise upset, a strong third-party candidate emerges after the primaries, capturing disaffected voters from both major parties and ultimately winning the 2024 US Presidential Election. Will 2024 be the Hottest Year on Record? Answer: Yes. What will be the …
Re: Concat values from same column with different conditions
Programming
Databases
10 Years Ago
by saadi06
The data that is to be displayed is height like 5ft 2 in.How can I show this using group concat
MySql LIKE returns 0 rows
Programming
Databases
12 Years Ago
by Tunnleram
I'm missing something stupid so I need another set of eyes. I have a session value set that's a group concat of a few ids and I want to check to see if an id found by a query is in that group concat. The group concat variable is $session_unitidgrouping The query doesn't return errors, but it doesn't return what I'd expect either. It returns …
Filtering logic
Programming
Databases
9 Years Ago
by Szabi Zsoldos
Hi guys, Trying to develop a custom facet like search in Mysql. I have 3 tables for this: 1.Attribute class 2.Attribute class Name 3.Attribute class Value - attributeClassName Id - productId 4.Products Each product has one attribute class Each attribute class has many values Each value is contained in a …
group_concat with limit
Programming
Databases
8 Years Ago
by abhi10kumar
How I can group concat of ids with limit 2 and order by id desc? Means, need all the ids except first two ids in desc order. select
group_concat
(id) as ids from private_tuition_teacher_pdf where client_id = 14 and teacher_id = 15 limit 2 order by id desc
Re: Need help for displaying movie database
Programming
Web Development
11 Years Ago
by diafol
Did my GROUP CONCAT DISTINCT query not work for you?
Re: Concat is not working in inclause
Programming
Databases
8 Years Ago
by pritaeas
`CONCAT` is a string function, am surprised you even get that one row. The query you get is: select c_id,c_name from category where c_id in ('870,854'); My guess is that the string is being casted to an int again, resulting in 870.
Re: Group of Death Simulation
Programming
Software Development
13 Years Ago
by StuXYZ
Group of death is directly dependent on the host nation, it would not be if the host nation didn't get put as the first team in the A group. If the host nation is a cat 3 team, no cat 3 team can play each other, but if the host nation is say a 1, then two things happen, a single 3 is going to either met the host nation or one of the other 3s. …
Re: Group Discussions
Community Center
Meta DaniWeb
14 Years Ago
by Dani
Group discussions are definitely something that I want to improve on in the near future, but unfortunately I'm devoting my time elsewhere right now. However, do expect a massive overhaul of discussions in a not-so-far away time.
Re: is order by and group by the same?
Programming
Databases
18 Years Ago
by chrisbliss18
"GROUP BY" and "ORDER BY" are very different. "GROUP BY" associates all records together based on a column. "ORDER BY" sorts a alphabetically based on column. Let's create some sample data for a table called Location. [code]name | state | city --------|-----------|--------------- Joe | …
Re: Please help me in a trouble with Oracle Express 10g Edition
Programming
Databases
13 Years Ago
by urtrivedi
group by is used to aggregate you data, you dont need group by so remove group by clause from your query. following is your query [code] SELECT Dname, Dnumber FROM DEPARTMENT [/code]
Re: Sql group by error in inner join please help me............
Programming
Software Development
6 Years Ago
by Santanu.Das
Group By clasue always produce a count or summation of another field. It never shows other feilds, if you tried to so the values of other fields without aggregating them it shows an error message. If you want to group by with a single field you only can get the aggregated fields. The syntax should be select p.prtgst,sum(prd.totaltaxamt)…
Re: PHP Mysql Query for order by first and then group by
Programming
Web Development
10 Years Ago
by Lsmjudoka
GROUP BY isn't intended for use like this, it's supposed to be used with a MySQL function like COUNT() or MIN() to return information about a resultset from multiple rows. If you want everything sorted by publisher name first, then by time, you simply need to run the query ordered by two columns: SELECT * FROM `table` WHERE `time` >= '…
Why is the ListView box showing same headings twice?
Community Center
4 Years Ago
by Papa_Don
Group, I've written some code to populate a listview using 3 fields from a database. When creating the listview, I named the individual columns for appearance purposes, (Account No, Company Name and Name). Those columns are being populated appropriately as expected. However data column names are being shown in column 4 5 and 6, but with no …
VBA in Excel - Check for Groups
Programming
Software Development
9 Years Ago
by Papa_Don
Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, I'm using the following code to group: …
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC