Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C
select the deptname where salary >=5000
result should be:
Deptname
---------
C
please post only executed query in SQL server 2005
Asked By: Md. Niyaz
Answer Posted / rajkumar
Select Deptname from Department Where salary >=5000
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I start sql server 2017?
Explain what are the events recorded in a transaction log?
What is simple indexing method?
What is the difference between web edition and business edition?
What are the differences between stored procedure and the dynamic sql?
between cast and convert which function would you prefer and why?
How to download and install the scaled-down database adventureworkslt?
What are joins in sql and what are the different types of joins?
What are cursors and when they are useful?
Write a sql query to get zero records from a table having n number of records?
What is transaction server implicit?
Explain about system database?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the report builder?
How can you find out which stored procedures are recompiling?