How to find out name of all employees who has salary less
than 200 Rs.?
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 the difference between web edition and business edition?
Is it true, that there is no difference between a rule and a check constraint?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What do you understand by recursive stored procedure?
What do you understand by check constraint in sql server?
What is difference between clustered and non clustered index?
When to use null data driven subscription?
What are the built in functions in sql server?
What is "scheduled jobs" or "scheduled tasks"?
How to test values returned by a subquery with the in operator?
How do you check sql server is up and running?
How to rebuild indexes with alter index ... Rebuild?
What is built-in/administrator?
How to fine-tune reports?
Write a query to find 5th highest amount paid from the customer table.