the Buy, attribute of the data table is the product product, department department, time time, so how to write the sql statement "products purchased by the sales department in 2014 but not purchased by other departments", I have been thinking about it for a long time, but I really can"t figure it out.
SELECT * FROM Buy WHERE id not in (SELECT id where department! = 'sell' and? > time >?) Where? > time >? And department = 'sell';
select distinct product from buy where department = 'sales Department' and left (convert (varchar (10), time,120), 4) = '2014' and
not exists (select distinct product from where department! =' sales Department 'and left (convert (varchar (10), time,120), 4) =' 2014')
this is the writing of sql server. I'm not sure if mysql is the same syntax, if the above functions are used differently. Baidu can do it in one fell swoop
--departmentintdepartment=5
SELECT DISTINCT product FROM [Buy]
WHERE department=5 AND time=2018 AND Title NOT IN
(
SELECT DISTINCT product FROM [Buy] WHERE department<>5 AND time=2018
)
--Previous: Ask a sql question
Next: Vuex and browser caching
subject table, which can be understood as a classification table. The course and source_book tables are associated with subject now use the subject table as the main table to query how many courses and books are under this category. query statemen...
background: 1. I am a java programmer 2. Recently interviewed for a senior development position 3. The previous project mainly used less oracle,mysql, and the companies interviewed basically used mysql s 4. I am weak in the database 5. Recently, I...
for example, if the database has a field type of enum ( axiomagementific database ), can you change this field to enum when there are millions of data in the database? will it be slow? ...
because batch update operations are always involved recently, I don t know if batch operations can be performed, so we can only update, one by one in the loop , so I d like to ask whether there is a sql statement in the sql database that enables updat...
jav inserts Mysql data exception Data too long exception information 2018-04-24 00:15:01 ERROR com.comall.cybershop.common.base.DaoSupport org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update cs_awardCardRe...
after entering the query statement, I kept turning and turning, but there was no response. Please see why http: www.nbjinshi.com bug.png. This is a screenshot. I couldn t upload the screenshot, so I had to upload it to my server ....
has a table, table_x, field A has a duplicate value: now you want to return the result of the sample diagram through the select query, counting the number of times the value of the corresponding field An is repeated. The ideal effect is shown in figur...
Name Class Score Zhang San Chinese 81 Zhang San Mathematics 75 Li Si Chinese 76 Li Si Mathematics 90 Wang Wu Chinese 81 Wang Wu Mathematics 100 Wang Wu English 90 use a SQL sentence to query the Name of the students with the lowest Chinese sco...
is there any way? such as recommended books, blogs, etc. ...
means there is no train of thought at all. if user An is only in the R & D group and id is 5, then the number after user An is 32 . How should I write this sentence? There is no external network. I don t know if I can see the pictures taken by pri...
(SELECT * FROM `dozhan_reply` t1 WHERE `reply_parent` IN ( SELECT `reply_id` FROM ( SELECT `reply_id` FROM `dozhan_reply` WHERE `reply_article` = 69 AND `reply_type` = 0 LIMIT 0, 5 ) t )) UNION (SEL...
SELECT * FROM `table_1` WHERE `reply_parent` IN (SELECT `reply_id` FROM (SELECT `reply_id` FROM `table_1` WHERE `reply_article`=69 AND `reply_type`=0 LIMIT 0, 5)AS t) UNION (SELECT * FR...
can you give me a column? ...
is like this, and the ultimate effect is to match the avatar address of the drink in the user table for each comment list first, query out the table_1 (article comment table) article comment result set then I found that these comments do not have...
there is a problem. What should I do if I want to take a record that matches multiple characters in a field? select * from actor where last_name like ( % DAVI% , MOSTEL% , ABC , kkk%aa ) the above sql statement is incorrect. Like does not sup...
these are the data of my two tables: flask: sqlalchemy: : ...
there seems to be no difference between the two SQL implementations. select * from A left join B on A.aid=B.aid where A.aid=100 select * from ( select * from A where A.aid=100 ) AA left join B on AA.aid=B.aid what do you think of SQL performing ...
is it feasible to delete and then insert when updating database tables? the contents of the table are many-to-many relationships ...
1. If you use select * from APowerB without any conditions, the result will be displayed associated with tables an and b, but the result will be repeated many times 2, and select * from a join b, will not add any query conditions, and the result will b...
DELETE FROM tusers WHERE (code,name) in(SELECT code,name FROM tusers GROUP BY code,name HAVING COUNT(*) > 1) Why can t I write like this? How do you write this? ...