Subqueries in SQL Server
- From: sangu_rao@xxxxxxxxxxx
- Date: 11 Jan 2007 21:03:27 -0800
Hi,
Is there any similar statement in SQL Server for the below Oracle query
SELECT ENAME FROM (SELECT ENAME FROM EMP WHERE DEPTNO = 10)
WHERE SUBSTR(ENAME,1,4) = 'SAHU';
The above one is a Oracle query, i want to know is there any equivalent
query in SQL server.
I don't want to write the query as
SELECT ENAME FROM EMP WHERE DEPTNO = 10 AND SUBSTR(ENAME,1,4) = 'SAHU';
Please provide your comments.
Thanks
Rao
.
- Follow-Ups:
- Re: Subqueries in SQL Server
- From: Peter W. DeBetta
- Re: Subqueries in SQL Server
- From: Dejan Sarka
- Re: Subqueries in SQL Server
- Prev by Date: Re: Scheduling Jobs Synchronously
- Next by Date: Re: Subqueries in SQL Server
- Previous by thread: Re: Scheduling Jobs Synchronously
- Next by thread: Re: Subqueries in SQL Server
- Index(es):