what is use of SQL Jion operators like =, <>, <=, <, >, >=,

Posted by Dot Net Team under Sql Server on 12/3/2011 | Points: 10 | Views : 927 | Status : [Member] | Replies : 4
What is the use of SQL Jion operators like = , <> , <= , < , > , >=.
'=' is use to Equal the table colume and others ?




Responses

Posted by: Varung on: 12/3/2011 [Member] Starter | Points: 25

Up
0
Down
<> not equals to
<= lessthan or equal to
< lessthan
> greater than
>= greater than or equal to

G.Varun

Dot Net Team, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dot Net Team on: 12/3/2011 [Member] Starter | Points: 25

Up
0
Down
It's OK...
'=' use to join like this
select EmpID,EmpName from Table1 INNER JOIN Table2 ON Table1.EmpID = Table2.EmpID
Result... return only comman records
same what is use (<> , <= , >= , < , >)

Dot Net Team, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
= EQUAL TO
<> NOT EQUAL
<= LESS THAN EQUAL
>= GREATER THAN EQUAL
< LESS THAN
> GREATED

EXAMPLE:

SELECT * FROM EMPLOYEESALARY WHERE EMPSALARY>3000

SELECT * FROM EMPLOYEESALARY WHERE EMPSALARY >8000

SELECT * FROM EMPLOYEESALARY WHERE EMPSALARY <> 1000

SELECT * FROM EMPLOYEESALARY WHERE EMPSALARY >=9000

HOPE THIS WILL HELP

REGARDS


sriram

Dot Net Team, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/11/2012 [Member] Bronze | Points: 25

Up
0
Down
select s.st_Name,q.Qualification from Student s inner join Qualification q on s.st_Quali_ID=q.st_Quali_ID where s.st_Quali_ID>=5 and s.cat_ID<=12 and s.st_Name<>'Meera'

Dot Net Team, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response