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
What are the advantages of having an index on the sql server?
What are the new features of sql server 2012 reporting service?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to use transact-sql statements to access the database engine?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What happens if an integer is too big for int date type?
What does indexation mean?
What causes index fragmentation?
What is normalization and what are the advantages of it?
What is shrink log file?
What are approximate numeric data types in ms sql server?
Can you explain the disadvantages/limitation of the cursor?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What are difference between Cluster index and Non-Cluster index?
Which sql server is best?