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
- 10437 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
How can I check that whether automatic statistic update is enabled or not?
What is bcnf normalization form?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What do you understand by mirroring and mention the advantages of the mirroring?
What does null mean?
How to backup encryption key ?
How to delete an existing row with delete statements in ms sql server?
What is the difference between cartesian product and cross join?
Why we need sql server?
Is it safe to delete log files?
how would you store your query in an SSRS report or a Database server?
What is the default server name for sql server?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the difference between varchar and nvarchar datatypes?
What is the use of for clause?
