Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5669 Views
- I also Faced
- E-Mail Answers
Answer Posted / maulesh
Select Deptname
From Department
Where salary >=5000
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How except clause is differs from not in clause?
How to create median function?
How to bind a view to the schema of the underlying tables?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How can you list all the columns in a database?
Explain having clause?
What are the differences between ms sql server & oracle?
What is data set in report?
Do you know the capabilities of cursors?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is cursor in ms sql server?
How to drop an existing table with "drop table" statements in ms sql server?
Does sql server 2000 clustering support load balancing?
If no size is defined while creating the database, what size will the database have?
How do I determine how many instances of sql server are installed on a computer?
