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
Answer Posted / guest
select deptname from department where salary>=5000
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Explain view in sql server?
What have included columns when we talk about sql server indexing?
What is transaction server implicit?
What is candidate key with example?
How to select some specific columns from a table in a query in ms sql server?
What is tabulation?
What does nvl stand for?
How can we migrate from SQL server to SQL Azure?
Does partitioning improve performance?
What are the differences between local and global temporary tables?
What do you mean by a dependent functionality in a build?
List the advantages of using stored procedures?
What is the difference between seek predicate and predicate?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How many types of built in functions are there in sql server 2012?