How to find out name of all employees who has salary less than 200 Rs.?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

How to find out name of all employees who has salary less
than 200 Rs.?

Question Posted / sapna

8 Answers
10576 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / bhaksar

select Emp_Name from emptable where sal < 200

Is This Answer Correct ?

26 Yes

2 No

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / praveen kumar.dandu

select ename from emp where sal<200

Is This Answer Correct ?

4 Yes

2 No

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / tasneemuddin

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

Is This Answer Correct ?

1 Yes

0 No

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / jay

select * from Employees where Salary <200

Is This Answer Correct ?

1 Yes

1 No

How to find out name of all employees who has salary less than 200 Rs.?..

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

Is This Answer Correct ?

1 Yes

1 No

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / afan

SELECT Name
From Employees
Where Salary<200

Is This Answer Correct ?

1 Yes

1 No

How to find out name of all employees who has salary less than 200 Rs.?..

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

Is This Answer Correct ?

0 Yes

2 No

How to find out name of all employees who has salary less than 200 Rs.?..

Answer / aditya

select *from <table name>where sal<20

Is This Answer Correct ?

7 Yes

11 No

Post New Answer