in C# I'd like to invoke the label edit of a newly added item to a ListView. basically, if I have a click here to add scenario, as soon as the new item is added, I want the text label to be in a user editable state. Thanks!
how do you programatically invoke a listview label edit
Old question I know, but this gave me a better exec plan:
SELECT TOP 1 LEAD(MAX (column)) OVER (ORDER BY column desc) FROM TABLE GROUP BY column
Microsoft SQL Server - Using Two TOPs for the N-th highest value (aliased sub-query).
To solve for the 2nd highest:
SELECT TOP 1 q.* FROM (SELECT TOP 2 column_name FROM table_name ORDER BY column_name DESC) as q ORDER BY column_name ASC;
Uses TOP twice, but requires an aliased sub-query. Essentially, the inner query takes the greatest 2 values in descending order, then the outer query flips in ascending order so that 2nd highest is now on top. The SELECT statement returns this top.
To solve for the n-th highest value modify the sub-query TOP value. For example:
SELECT TOP 1 q.* FROM (SELECT TOP 5 column_name FROM table_name ORDER BY column_name DESC) as q ORDER BY column_name;
Would return the 5th highest value.