how to do this sql server query

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

Hi all,

id name status
1 harry 5
1 harry 10
1 harry 15
2 barry 5
2 barry 10
3 ben 5
3 ben 10
3 ben 15
4 ian 5
4 ian 10
5 jolly 5
5 jolly 10

Output

I need the employee whose status doesn't have 15

barry
ian
jolly

Thanks

Posted 31-Jan-12 17:12pm

3796068

Add a Solution

4 solutions

Solution 1

SQL

Select id,name,status from Employee where Status!=15

It is a very basic query of SQL. You must know these. Please learn it yourself.

Best of Luck!

Posted 31-Jan-12 17:17pm

Sanjay K. Gupta

Solution 2

first learn the basic query from www.w3schools.com website.this is good website for beginner

Select id,name,status from Employee where Status!=15

Posted 31-Jan-12 17:20pm

khan mohd faizan

Comments

3796068 31-Jan-12 23:31pm

Dear sir,Your query is not working.Its showing all names but i only need barry
ian
jolly

Thanks

Solution 3

Hi,

this will help

Declare @Employee table
(
  id int,
  name varchar(50),
  status1 int
)

Insert Into @Employee 
values 
(1, 'anvas',10),
(2, 'anvas',5),
(3, 'Deepthi',15),
(4, 'Sudeep',15)

Select distinct(name) id,status1 from @Employee where Status1!=15

Posted 31-Jan-12 18:29pm

anvas kuttan

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amir Mahfoozi · Accepted Answer · 2012-01-31T18:50:00

Solution 4

Here it is :

SQL

SELECT  distinct name
  FROM TableName e
  where not exists(select id from TableName where status = 15 and name = e.name)

Change TableName to your table name !

Hope it helps

Posted 31-Jan-12 18:50pm

Amir Mahfoozi

Comments

3796068 1-Feb-12 11:09am

Thanks brother(Amir) for the help.

Amir Mahfoozi 2-Feb-12 3:30am

You're welcome brother :)

how to do this sql server query

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

how to do this sql server query

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us