Answer / bhaksar

select Emp_Name from emptable where sal < 200

Answer / praveen kumar.dandu

select ename from emp where sal<200

Answer / tasneemuddin

Select <Employee Name Field> From <Table Name> Where <Salary
Field> < 2000

Answer / jay

select * from Employees where Salary <200

Answer / manu

select emp<e name field>,sal<Sal field> from employees <Table name>
where sal<Sal field> < 200

Note: Field = Table column name......


enjoy... this is simple query

Answer / afan

SELECT Name
From Employees
Where Salary<200

Answer / juergen

Is this a real question???? First off, with all the
asterixes is wrong. Just want the employees.

select AiFirstName, AiEmpLastName
from AiEmployees
where AiSalary < 200

Answer / aditya

select *from <table name>where sal<20

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

Which Model uses the SET concept

0 Answers   Infosys,

What is trace flag in sql server?

0 Answers  

What is sql view?

0 Answers  

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

When do u use clustered index and non-clustered index?

3 Answers   IBM,

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

How to convert a unicode strings to non-unicode strings?

0 Answers  

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

What gets stored inside msdb database?

0 Answers   Abacus,