Search results
SELECT * FROM member WHERE email = (Select email From member Where login_id = [email protected]) This will return all records that have [email protected] as a login_id value. Share
select purpose.pname,company.cname from purpose Inner Join company on purpose.id=company.id where pname='Fever' and cname='ABC' in ( select mname from medication where mname like 'A%' order by mname );
30 lis 2013 · I need to find out the records where the article_title data is the same on more than one record. Here's what I've got: select a.* from articles a where a.article_title = (select article_title from articles where article_title = a.article_title AND a.id <> articles.id)
30 wrz 2014 · Recommended way: "SELECT *" vs "SELECT COLUMN_LIST" from same table, multiple times
2 mar 2017 · MySQL does not have it, but there is a universal method that works in most products, including MySQL: conditional aggregation. SELECT user_id, MAX(CASE meta_key WHEN 'first_name' THEN meta_value END) AS first_name, MAX(CASE meta_key WHEN 'last_name' THEN meta_value END) AS last_name, MAX(CASE meta_key WHEN 'street_add' THEN meta_value END) AS ...
25 paź 2023 · MySQL includes some nonaggregate window functions that allow us to get a value from a specific row. We can use such functions to do things like, compare the value in the specified row with the value in the current row, even if both values are in the same column.
You can use a WHERE clause to combine row selection with column selection. For example, to get birth dates for dogs and cats only, use this query:
