SQL AND, OR and NOT Operators | Tutorial in Tamil | Tamil Programmer
HTML-код
- Опубликовано: 21 окт 2024
- not operator, not operator tamil,sql, sql for beginners, sql full course, sql injection, sql joins
#TamilProgrammer #Programming #ProgrammingLanguage #TamilTutorials #ProgrammingTutorialTamil #Database #SQLDatabase #SQLDatabaseInTamil #SQLDatabaseTutorialInTamil #DatabaseTutorialInTamil #MSSQL #MSSQLTutorialInTamil #ANDOperators #OROperators #NOTOperators
You will get a better understanding of AND, OR, and NOT operators in MS SQL database with suitable example
Subscribe To My Channel: / @tamilprogrammer8071
For eg. I want a result where coursename and course duration should be or of each other not and of each other
How to use put a query with all these logics together?
Thank you for your comment, hope below given example help you.
SELECT
StudentID,
StudentName,
Branch,
Score,
ExamName
FROM
Students
WHERE
Branch = 'Metro Campus'
AND (Score > 50 OR ExamName IS NULL)
AND NOT (Score < 50)
ORDER BY
StudentName;
Update delete in and ,or ,not where bro