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
- 10202 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
Which are the two editions in which SQL Azure database available?
What is partition index in sql server?
What is an identity?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is the boxing and unboxing concept in .net?
What is indexed view? How to create it?
can a database be shrunk with users active? : Sql server administration
Explain about SQL server 2005?
You want to implement the many-to-many relationship while designing tables. How would you do it?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Which are the new data types introduced in sql server 2008?
How to skip remaining statements in a loop block using continue statements?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to create a stored procedure with a statement block in ms sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
