Home » SQL & PL/SQL » SQL & PL/SQL » sql query
sql query [message #198111] Sun, 15 October 2006 00:58 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
hello,
i want to get details to whom no body is reporting.

SQL> SELECT * FROM EMP2;

E_NO E SAL MGR
---------- - ---------- ----------
1 A 5000
2 B 1600 1
3 C 1900 1
4 D 4000 2
5 E 4500 3
6 F 9100 1
7 G 5000 1
8 H 4000 2

thanxx in advance
Re: sql query [message #198116 is a reply to message #198111] Sun, 15 October 2006 02:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please read the sticky (first post in the forum) and use its guidelines when you post.
- Use code tags [code]...[/code]
- issue create table and insert statements
- and most important: Do try things yourself before asking. You ask quite a lot of questions, which is no problem, but you never ever show any effort you put into it yourself. Show what you tried and where you are stuck.

Remember: orafaq is NOT a sql-generator. We are here to help you out but more important: to help you LEARN!
Re: sql query [message #198130 is a reply to message #198116] Sun, 15 October 2006 12:35 Go to previous messageGo to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
ok frank.
it means orafaq is not for my type of people who want help from u? i m posting my queries on slq newbies not in sql experts.. if i m not permit to post my query in this section plz suggest me where should i post.whenever i failed to solve my queries then only i post.if u feel such quetion meaningless dnt answer but u r not suppose to write thing like that what u have wrote me.
dnt take it by heart.

i actually need ur help.its upto u, whether u consider my queries or not?
thanx
Re: sql query [message #198133 is a reply to message #198130] Sun, 15 October 2006 13:37 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Ashish,

Why are you taking this so seriously. I mean we all are here to co-operate each other and what Frank has said is right. What ever you are doing just send a copy of that in the forum.

As far as for your query 'use equijoin to generate the output. Lesson 5 of the Jouchman will help you.'

Bye
Ashu


Re: sql query [message #198163 is a reply to message #198133] Sun, 15 October 2006 23:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
@ashish_pass1:
You obviously didn't follow my advice to read the sticky. Apart from not understanding what I meant, when I said you had to give it a try first, you are also introducing IM-speak into your posts!
Re: sql query [message #198213 is a reply to message #198111] Mon, 16 October 2006 03:34 Go to previous messageGo to next message
vijayanarayanan
Messages: 11
Registered: September 2006
Location: chennai
Junior Member
THIS IS THE SYNTAX FOR FIND ALL THE EXMPLOYEES NOT MANAGERS:
select *
from table1 t1
where NOT EXISTS(select 'x' from table 1 t2 where t2.manager_id = t1.employee_id);
Re: sql query [message #198216 is a reply to message #198213] Mon, 16 October 2006 03:49 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
vijay,
although we appreciate active members we:
  • try to teach how one can solve a problem himself (teach a man how to fish...)
  • try to make people actively think about the questions they ask so they can help themselves next time
  • are not a "homework answer generator forum"
  • don't appreciate upper case posts (it give the reader the impression you're is shouting
  • don't appreciate IM speak. It is not very professional/polite
  • try to make people read the posting guidelines. I suggest you do to. It is the first topic in this forum.


ashish,
you are very much welcome to post questions here but try to:
  • read the guidelines (tips&tricks)
  • follow them (especially about IM speak and the use of code tags).
  • show us what you did.

If you post your try we can correct you and explain why it was not correct. That way you can understand what went wrong and you won't make the same mistake twice.

MHE
Re: sql query [message #198225 is a reply to message #198216] Mon, 16 October 2006 04:03 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
thanxx maher,vijayanarayanan, ab_trivedi, Frank.
now i m getting u all.
i hav to post question along with my queries what i had done mistake. so that u will make me clear of that.
thanx a lot to u all. Razz
Previous Topic: change columns into rows n rows into columns
Next Topic: Problem with ALTER TABLE...MODIFY CONSTRAINT...
Goto Forum:
  


Current Time: Mon Dec 05 21:30:43 CST 2016

Total time taken to generate the page: 0.05459 seconds