How to find out name of all employees who has salary less
than 200 Rs.?
- 8 Answers
- 9095 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 is spatial and temporal data?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is inner join in sql server joins?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is transaction server explicit transaction?
What are ddl triggers and types of ddl trigger?
What is reference section?
What is buffer cash in sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Which are the new data types introduced in sql server 2008?
What is #temp and @table variable in SQL server?
What is resource governor?
What are security principals used in sql server 2005?
Explain the different types of joins?
What is a select query statement in ms sql server?
