Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
3-1 in Outer Query
This is a discussion on 3-1 in Outer Query within the SQL forums, part of the Databases category; select salary from employees e where 3-1=(select count (distinct salary) from employees where salary >e.salary); What is 3-1 in outer query?...
|
|||||||
10-12-2009
|
|||
|
|||
|
3-1 in Outer Query
select salary from employees e where 3-1=(select count (distinct salary) from employees where salary >e.salary);
What is 3-1 in outer query? 
|
| Sponsored Links |
|
10-12-2009
|
|||
|
|||
|
Re: 3-1 in Outer Query
that is a simple subtraction and it is compared the count of inner query.
|
|
2 Weeks Ago
|
|||
|
|||
|
Re: 3-1 in Outer Query
just finding 3rd highest salary in emp table..
__________________
Sireesha
|
|
2 Weeks Ago
|
|||
|
|||
|
Re: 3-1 in Outer Query
it will get 2nd lowest salary
bcoz 3-1 is 2 , in the inner query u have mentioned the condition salary >e.salary . it will sort in assending order
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outer Join Between Dimension tables | Himanshu_sh | Data Warehousing | 1 | 03-06-2009 06:40 AM |
| SQL Server outer join | chitrab | SQL Server | 3 | 03-28-2008 04:51 AM |
| Outer Join Query Example | mailtos.ravi | SQL | 4 | 03-05-2008 04:34 AM |
| Recognising only outer form boundary | Geek_Guest | QTP | 1 | 03-03-2008 02:06 AM |
| Writing query with LEFT OUTER JOIN | N SRIRAM K | Data Warehousing | 5 | 09-03-2007 06:08 AM |
All times are GMT -4. The time now is 02:52 PM.
