Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361393 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 / ved
select sal from emp
where limit,1
order by sal desc
| Is This Answer Correct ? | 12 Yes | 20 No |
Post New Answer View All Answers
What is sql performance tuning?
How exception is different from error?
what is 'mysqlcheck'? : Sql dba
What is case function?
What are the various restrictions imposed on view in terms of dml?
Why is stored procedure faster than query?
Advantages and disadvantages of stored procedure?
Explain what is a column in a table?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What are the 3 modes of parameter?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is scope of pl sql developer in future?
Name the operator which is used in the query for pattern matching?
Are stored procedures compiled?
Can you call pl/sql package functions from within a fast formula?
