[Solved] How to Translate this statement in MS Access Query?

First of all get all the duplicate records by using group by and having clause select * from table where (Document_No,Distribution ) in ( select Document_No,Distribution from table group by Document_No,Distribution having count(*) >1 ) or select t1.Document_No,t1.Distribution from table t1 join (select Document_No,Distribution from table group by Document_No,Distribution having count(*) >1 ) as t2 … Read more

[Solved] What is wrong about this SQL statement? [closed]

You can’t use IF as a statement in a query, it can only be used in a stored procedure. To do what you want, you need two separate queries. Try this: $del_query = “DELETE FROM favoritebills WHERE userid = ‘$userid’ and billid = ‘$billid'”; $ins_query = “INSERT INTO favoritebills (userid,billid) VALUES($userid,$billid) “; $res = mysqli_query(dbcxn(‘bill’),$del_query) … Read more


for get the first 100 records for a table we use the limit clause. See the following Example. Question: Get the first 100 persons that his name is starting for John Answer: Select * from pearson where name like ‘John%’ limit 100 solved SQL Query SELECT RECORDS

[Solved] Need Help,There’s no error but can’t go to another form for this multi user form code(c#) [closed]

The Error is because you haven’t open the connection before using it. First open the connection with the line “myCon.Open();” before using it in SqlDataAdapter and then use the ‘=’ operator in the select query of the where clause. you have missed that too in your query. Your code should be private void trydb() { … Read more

[Solved] SQL Group by and intersect between internal columns [closed]

SELECT Category, Tag1Value FROM table_name t1 WHERE EXISTS (SELECT 1 FROM table_name WHERE Tag2Value = t1.Tag1Value) UPDATE Try this : SELECT res.Category, res.tag, COUNT(res.tag) FROM (SELECT DISTINCT Category, Tag1Value tag FROM table_name UNION ALL SELECT DISTINCT Category, Tag2Value tag FROM table_name) res GROUP BY res.Category, res.tag HAVING COUNT(res.tag)>1 It return : category | tag ———————————– … Read more

[Solved] Can I know the issue of this SQL query

It’s because a CASE WHEN can only return 1 value. And a STRING_SPLIT returns a resultset. I assume something like this is what you want. SELECT * FROM Facility f WHERE (@Facility IS NULL OR f.facilityCode IN (SELECT value FROM string_split(@Facility,’,’))) This will get all records if the variable is null. 2 solved Can I … Read more

[Solved] Select from Select [closed]

If I understand correctly what you want you just need to JOIN with Car table like this SELECT c.PlateNo, TicketStatus, EventTime FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY CarID ORDER BY EventTime) AS rnum , CarID, TicketStatus, EventTime FROM Event ) a JOIN Car c ON a.CarID = c.CarID WHERE c.Package = 4 AND a.rnum … Read more