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
- 6712 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra10shekhar
SELECT * FROM department WHERE salary>=5000
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to override dml statements with triggers?
Why do we use trigger?
What are the system database in sql server 2005?
How do I edit a procedure in sql server?
How to convert numeric expression data types using the cast() function?
Do you know how to send email from database?
How do you improve the performance of a SQL Azure Database?
Can the query output be sorted by multiple columns in ms sql server?
Write a sql query to display the current date?
Do you know what is difference between stored procedure and user defined function?
What is extended stored procedures?
What are advantages of ssrs or why we should use ssrs?
Explain system rowset functions?
What is blocking?
List the different types of joins?
