Interested to Buy Any Domain ? << Click Here >> for more details...
Find 2nd Highest salery in emp table
Select* from emp where &n=
select * count from emp where (salery >=emp.salery)
Enter n value 2
These query is correct or not. Tell me any other methods.
- 6 Answers
- 8008 Views
- I also Faced
- E-Mail Answers
Answer Posted / r.rajivgandhi
Select max(salary) from emp where salary <(select max
(salary) from emp)
These Query is correct.Try It
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to remove duplicate rows from table?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Working with TLogs
mention different types of relationships in the dbms?
How to convert character strings into numeric values?
Explain where clause?
Which language is supported by sql server?
How to create user defined functions with parameters?
Do you know the different ddl commands in sql?
How does clustered and non clustered index work?
What is encryption key?
Which are the third-party tools used in sql server and why would you use them?
What is the difference between stored procedure and functions?
Does sql server use java?
can you instantiate a com object by using t-sql? : Sql server database administration
