Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out name of all employees who has salary less
than 200 Rs.?
- 8 Answers
- 10777 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what method you can use to reduce the overhead of Reporting Services data sources?
Why do we need different type of parameter?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain “not null constraint” in sql server?
What is the use of floor function in sql server?
What is the openxml statement in sql server?
What is the report model project?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What do you understand by the data quality services in sql server?
What is the default value of an integer data type in sql server 2005?
What is field in algebra?
Do you know what are the ways available in sql server to execute sql statements?
What is difference between count (*) and count column?
what is a traditional network library for sql servers? : Sql server database administration
What is the beast way to write CTE in SQL Server ?
