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 |
why would you call update statistics? : Sql server database administration
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
How to replace the Query Result 'Null Value' with a text ?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What are information schema views?
How does a profiler work?
How to convert character strings into numeric values?
What does the automatic recovery do?
What are temporal tables in sql server 2016?