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 / arbind panigrahi
select * from deptname where salary<=5000
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is BLOCK statements in SQL?
What options are available to audit login activity? : sql server security
What happens if you are trying to access a schema not owned by you?
What is the default port for SQL Server over a firewall?
What are the two authentication modes in sql server?
What is isolation levels?
What are cascading parameters in ssrs reports?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is tablix?
What are rows and columns?
What is a hint?
Can we update data in a view?
How you can get a list of all the table constraints in a database? : Sql server administration
Explain datetime2 data type in sal server 2008?
Show Practically Sql Server Views are updatable?