SELECT Operatings

24/05/2011 13:27

--SELECT OPERATIONS :-

--Select operations are used to fetch the values from the table in diff format :-

SELECT *
FROM    dbo.TblEmpDetails with (NOLOCK)


SELECT    'EmpID is :' + EmpId +'sss',EmpName,Address,DOB
FROM    dbo.TblEmpDetails with (NOLOCK)


SELECT    EmpId AS "Employee Id",
    EmpName as "Employee Name",
    Address,
    DOB as "Date Of Birth"
FROM    dbo.TblEmpDetails with (NOLOCK)



SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    EmpId='EMP100'


SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    EmpId='EMP100' and Address='Namakkal'


SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    EmpId='EMP100' OR Address='Namakkal'


SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    EmpId <> 'EMP100'


SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Address IN ('Namakkal','Chennai','Madurai')


SELECT    EmpId,EmpName,Address,DOB
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Address NOT IN ('Namakkal','Chennai','Madurai')


SELECT    *
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Salary > 50000.00


SELECT    *
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Salary <= 50000.00


SELECT    *
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Salary  BETWEEN 10000.00 AND 60000.00


SELECT    *
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Salary  NOT BETWEEN 10000.00 AND 60000.00


SELECT    *
FROM    dbo.TblEmpDetails WITH (NOLOCK)
WHERE    Salary <= 50000.00 AND Address='Chennai' AND Age >25 AND Country='India'



 

Back