if the picture is a table, how to find the data equal to 8 in the three fields of mobile1 or mobile2 or mobile3
although you can use where or, ask God how to write sql statements if you don"t use where or. Ask for advice
if the picture is a table, how to find the data equal to 8 in the three fields of mobile1 or mobile2 or mobile3
although you can use where or, ask God how to write sql statements if you don"t use where or. Ask for advice
--8
--
SELECT Id,mobile1,mobile2,mobile3 FROM [Table]
WHERE Id NOT IN
(
SELECT Id FROM [Table]
WHERE mobile1<>8 AND mobile1<>8 AND mobile1<>8
)Previous: How to achieve different screen splits in vue?
Next: What template engine recommendation is there at the front end?
how to check the total number of records returned by answering query conditions in query pagination: select top 10 * from (select row_number() over(order by id asc) as rownumber,* from com_system_menu) temp_row where rownumber>((2-1)*10); the nu...