New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Solved
SQL Server sub query
Posted on 2012-12-20
New to SQL Server, need to write this sql statement (Oracle Format) in SQL SERver
SELECT count(*) FROM
(SELECT empno, ename, JOB, sal FROM emp)
SELECT count(*) FROM
(SELECT empno, ename, JOB, sal FROM emp)
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses
Course of the Month9 days, 3 hours left to enroll
604 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.