how to judge two sql queries of different forms have equivalent semantic?
Verify that two SQL query statements are equivalent - problem statement: since the same query can be written in different forms, how do you determine that two SQL query statements of different forms have equivalent semantics?
Yes , they must have. Like 'and' and '&&' produce the same result. && is just another way of representation of 'and'
if they give same result , then the SQL queries are same
This is very good question 👍👍
Siddharth Golecha Do they have the same ASTree(Abstract Syntax Tree) if two sql queries are same ?
use the same two querie to search a Large volume of information in general you will not see the difference but there will be a slight difference in there speed of getting the results.