Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
How to find 2nd highest salary
create table sal ( id int, sal float ) insert into sal values(1,100),(2,500),(3,400),(4,200),(5,400),(6,350),(7,350) select * from sal order by sal desc ; with cte as ( select * , dense_rank() over (order by sal desc)dn from sal ) select id, sal from cte where dn = 2 select * , dense_rank() over (order by sal desc)dn from sal
run
|
edit
|
history
|
help
0
Using pre-built schema in sql server
The relational division
Delete cascade
Sql server
SinghDestiny
Query through an error in Sql Server 2008 r2
Demo
SS my sql server 2014 4/7
Insert With Output Cluase
Where, And