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 |
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
In which files does sql server actually store data?
Difference between report and query parameter.
What is Dependency Injection and provide example?
What are the different types of upgrades that can be performed in sql server?
What does it mean to normalize a database and why would you do it?
What are transactions in sql?
can we have a nested transaction? : Sql server database administration
What is a mutating table error and how can you get around it?
What is a data collection table?
There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9
Explain about extended stored procedure?