Which of the following statement is correct for using comparison operators in SQL?

Question:Which of the following statement is correct for using comparison operators in SQL?

1.SELECT * FROM user WHERE id>50 and id <80

2.SELECT * FROM user WHERE id>50 and <80

3.SELECT * FROM user WHERE id>50 and where id <80

4.SELECT * FROM user WHERE id>50, where id <80


Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!