How to find out name of all employees who has salary less
than 200 Rs.?
Answers were Sorted based on User's Feedback
Answer / praveen kumar.dandu
select ename from emp where sal<200
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / tasneemuddin
Select <Employee Name Field> From <Table Name> Where <Salary
Field> < 2000
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
explain different types of backups avaialabe in sql server? : Sql server database administration
what is Buffer cash and Log Cache? Can you Explain it?
what is replication? where do u use Go Keyword?
What is the purpose of object explorer and its features? : sql server management studio
Explain sql delete command?
What is a constant or literal in ms sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
Do you know what are the reporting services components?
Name three version of sql server 2000 and also their differences?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is an identity?
Why do we use sql limitations? Which constraints can we use while making a database in sql?