Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361395 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / harish
select max(sal) from
emp where sal <(select max(sal) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we create clustered index without primary key?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Is sql a backend language?
how to return query output in html format? : Sql dba
What is the use of partition by in sql?
What are the types of operators available in sql?
What steps server process has to take to execute an update statement?
What is nosql db?
What are the sql commands?
Explain how to use transactions efficiently : transact sql
what is the difference between a web-garden and a web-farm? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do you delete a table?
What plvcmt and plvrb does in pl/sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
