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

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

What is a SQL Server Temporary Table?

1 Answers   Wipro,

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

Explain Different types of Projects?

1 Answers  

Does an index slow down updates on indexed columns?

0 Answers  

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

What's the information that can be stored inside a bit column?

0 Answers  

What is the process of normalization?

0 Answers  

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

How to skip remaining statements in a loop block using continue statements?

0 Answers  

What is pessimistic concurrency?

0 Answers  

What are page splits? : SQL Server Architecture

0 Answers