i need to know how i display department which has salary >
=5000 for the below table
Department
-----------
salary deptname
1000 a
3000 a
2000 b
3000 b
4000 c
5000 c
kindly send the query to thilakvinoth13@gmail.com
- 6 Answers
- 6720 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
select deptname from department where salary>=5000
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the difference between cartesian product and cross join?
How can you find out which stored procedures are recompiling?
What are the acid properties?
How to resolve the orphan use problem? : sql server security
What is difference between delete and truncate commands?
What is measure group, measure? : sql server analysis services, ssas
What is the difference between functions and stored procedures?
What are locks in sql?
Using the customer, and order table in northwind database, please write a query to produce xml?
what is spatial nonclustered index
How many databases can we create in a single server?
How would you go about developing a ssrs report?
How to see the event list of an existing trigger using sys.trigger_events?
Explain the steps to create and execute a user-defined function in the sql server?
What are the types of sql server?
