SQL SELECT TOP N (most expensive, high salary)
Sunday, October 28, 2007
SQL SELECT TOP N equivalent in ORACLE and MySQL (The most common database/Sql Interview Question)
Something I needed today... I wish this was standarized, but it is not, so here are some examples:
SQL Server:
SELECT TOP 10 product, descr, email
FROM products
ORACLE:
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10
MySQL:
SELECT product, descr, email
FROM products
LIMIT 10
Now i only want to show the top 5 records how do i do this?
Answer:
Here is the SQL to display the top-n items:
SELECT ENAME, SAL
FROM (SELECT ENAME, SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM < 4;
If you are using Oracle 9i you can use the RANK function also.
select *
from (select empno,sal,rank() over (order by sal desc ) rnk from emp)
where rnk <= 5;
thats all! Njoy...
Labels: high salary), MySQL, oracle, SQL Server, Top-n rows (most expensive
posted by MIGHTYMAK @ 10:03 AM,
,
PATNI SET UPS THE LARGEST IN SOFTWARE PARK IN AIROLI WITH 17000-SEAT
Sunday, October 7, 2007
Patni knowledge park (PKP), as the new campus has been named, has been ready since 2005-end. Patni had already acquired 50 acres of land in the MIDC technology park in Airoli, Navi Mumbai.
Phase I of the project, which had entailed an investment of Rs 230 crore, has been completed in early 2005. It has accommodated more than 5,000 professionals. The software park will then be ramped up to its full capacity when new projects are bagged, said Patni officials.
Phase - II is Under Contruction as on September 2007
Narendra Patni, chairman and CEO, said, "We are committed to enhancing our position as a leading Indian provider of integrated IT services and to strengthen our delivery capabilities. This knowledge park is a major step towards this effort."
"The Knowledge Park will meet the needs of Patni's rapidly growing business requirements by providing end-to-end IT off-shoring services for clients in insurance, financial services, manufacturing and other verticals. This will enable Patni to quickly ramp up operations to meet dynamic client requirements and also venture into new high-growth verticals," he added.
Labels: airoli, batch 2007, biggest software, IT park, manesh koovappillil, midc technology park, navi mumbai, patni, patni computer system, patni knowledge park, projects, scormak, software park
posted by MIGHTYMAK @ 4:27 PM,
,