SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
I Need Query urgent I Need Query urgent

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 02-23-2008, 03:26 AM
kondapallikalyan kondapallikalyan is offline
Junior Member
  
Join Date: Feb 2008
Posts: 1
kondapallikalyan is on a distinguished road
Arrow ANY dialect question:

I Need Query urgent

Display the details of those employees who do not have any person
working under him? from emp table
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 02-23-2008, 09:39 AM
Dimitar
 
Posts: n/a
Default ANY answer. Re: I Need Query urgent
SELECT e.* FROM emp e WHERE NOT EXISTS (SELECT a.* FROM emp a WHERE a.emp_supervisor_no=e.emp_no);
May be?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Reply

« 3 table merge? | Table Matching with subquery »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:54 PM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8