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
- 8257 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 many cores do I need for sql server 2016?
What is mapping schema?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
How to set database to be read_only in ms sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How we can compare two database data?
Explain candidate key, alternate key, and composite key?
What have included columns when we talk about sql server indexing?
How can you check the version of sql server?
How to verify the port number of the sql server?
What is database white box testing?
How to create nested stored procedure?
Explain alternate key, candidate key and composite key in sql server?
How dts is used to extract, transform and consolidate data?
