What is the difference between WHERE AND IN?
OR
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?
Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C
select the deptname where salary >=5000
result should be:
Deptname
---------
C
please post only executed query in SQL server 2005
Asked By: Md. Niyaz
Insert syudents details in table.Current system date &time
insert into joining time.How do insert?( in sysdate only
return current system date how do add time?)
62
1
01
101
01010
117
role of sql sever 2005 in database rather than any other
database