how to judge two sql queries of different forms have equivalent semantic?

Question

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?

Answer 1

Yes , they must have. Like 'and' and '&&' produce the same result. && is just another way of representation of 'and'

Answer 2

if they give same result , then the SQL queries are same

Answer 3

This is very good question 👍👍

Answer 4

Siddharth Golecha Do they have the same ASTree(Abstract Syntax Tree) if two sql queries are same ?

Answer 5

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.