Where id> 50 order by id and order by id> 50 what's the difference?-CodePudding

Home > database > Where id> 50 order by id and order by id> 50 what's the difference?

Where id> 50 order by id and order by id> 50 what's the difference?

Time：03-20

As title, recently in the database, the school set up a platform in question, output requirement is to ignore the order only contrast data

Then use the

 select * from Student where id & gt; 50 order by id;

 select * from Student where id & gt; 50;

All wrong, but the following statement is right, what is the difference between them?

 SELECT * FROM Student order by id> 50;

Really confused