No announcements
Found 924589 threads
-
0 VotesSELECT statement to find highest values
I tried the simpler code first: SELECT TOP 5 <columnName> FROM <tableName>.Answered | 6 Replies | 4417 Views | Created by Techie_Jones - Wednesday, September 16, 2009 3:38 AM | Last reply by Techie_Jones - Wednesday, September 16, 2009 8:20 PM
-
0 Votes
creating a view problem with revision
t.revision ) Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ ...Answered | 3 Replies | 783 Views | Created by LucasBan - Wednesday, July 2, 2014 10:29 AM | Last reply by Visakh16 - Wednesday, July 2, 2014 11:05 AM -
2 Votes
selecting 3rd highest id from table
Hi all, just to addition - in SQL 2012 you can use this query select OrderID, quantity from tableName order by OrderID ...Answered | 4 Replies | 2467 Views | Created by Bibek Gautam - Tuesday, May 8, 2012 11:24 AM | Last reply by Sergey Khanzhin - Tuesday, May 8, 2012 11:35 AM -
0 Votes
Select all records with highest dates
If I have three records, two of which have the same highest date, would I need to use a TOP method, rather than MAX, as this would return two records?Answered | 11 Replies | 4978 Views | Created by Leeroyster - Monday, March 22, 2010 11:15 AM | Last reply by Leeroyster - Monday, March 22, 2010 2:42 PM -
0 Votes
Settings for highest compatability and highest quality...
Since your original question was about highest quality and max compatibility, I suggested CBR because it will offer more users with borderline perf PCs to enjoy the higher ...Answered | 14 Replies | 6925 Views | Created by rizzer - Monday, December 28, 2009 5:46 PM | Last reply by Eric Juteau - Friday, January 1, 2010 5:57 PM -
2 Votes
select records with the highest value grouped on another value
;with cte as ( select VIN,Milo,Reg,QuoteID, ROW_NUMBER() over(partition by Reg order by QuoteID desc) as rn from yourtable) select * from cte where ...Answered | 3 Replies | 2439 Views | Created by Zoe.Ohara - Thursday, May 24, 2012 11:05 AM | Last reply by Eshani Rao - Thursday, May 24, 2012 11:21 AM -
1 Votes
Highest Average
DateTime.Now), new TagLocationHistory(2, 54, DateTime.Now.AddSeconds(2)), new TagLocationHistory(3, 53, DateTime.Now.AddSeconds(3)), new ...Answered | 3 Replies | 516 Views | Created by Darren Rockett - Wednesday, September 7, 2016 1:10 PM | Last reply by Darren Rockett - Wednesday, September 7, 2016 3:28 PM -
0 Votes
how to sort select highest value in column ?
SELECT Row_Number() over (Order by Name desc) as ID , name , address from tbl order by name desc; Russel Loski, MCT, MCSE Data Platform/Business ...Answered | 1 Replies | 792 Views | Created by srajmuneer - Friday, September 19, 2014 12:20 PM | Last reply by Russ Loski - Friday, September 19, 2014 12:32 PM -
0 Votes
second highest
select top 1 * from (select top 2 Balance from dbo.Table1 order by Balace desc)as TempTable order ...Answered | 3 Replies | 3304 Views | Created by prikshna - Sunday, September 25, 2011 9:19 AM | Last reply by deekshith b - Monday, September 26, 2011 9:31 AM -
0 Votes
Documentation revisions??
Question for MSFT, is it ok for Brad to give me a copy of the in-between revisions?Answered | 7 Replies | 5722 Views | Created by John W C - Monday, March 29, 2010 7:18 AM | Last reply by Mark Miller 01011001 01101111 - Tuesday, April 6, 2010 6:09 PM -
0 Votes
Select 10% from total employees who have the highest salary
SELECT TOP 10 PERCENT * FROM TableName ORDER BY Salary DESC Hope its helpful...Answered | 4 Replies | 4939 Views | Created by Vinh Khanh Le - Wednesday, April 28, 2010 4:54 AM | Last reply by Kalman Toth - Monday, May 3, 2010 7:58 PM -
0 Votes
Baseline and Revisions
Hello, Is there an out of the box baseline and revisions functionality for lists in SharePoint?Answered | 2 Replies | 1324 Views | Created by Hani Dean - Friday, May 13, 2016 4:27 PM | Last reply by Alex Brassington - Saturday, May 14, 2016 9:41 AM -
0 Votes
two highest rows for the given column
Try: select distinct * from ( select code, renewalnumber, dense_rank() over(partition by code order by renewalnumber DESC) as ...Answered | 2 Replies | 3517 Views | Created by anki2010 - Friday, June 17, 2011 6:52 PM | Last reply by anki2010 - Friday, June 17, 2011 8:54 PM -
1 Votes
Identifying duplicates and then displaying a the highest value
Hi sasha, try below query to solve your problem Select ParticipantId, QualificationLevelId From (Select ...Answered | 2 Replies | 1189 Views | Created by Sasha838 - Wednesday, June 5, 2013 7:47 AM | Last reply by Bhushan W Juare - Monday, June 10, 2013 7:46 AM -
0 Votes
Select Highest Revision
for this one I would suggest two ways : SELECT T.Proposed | 3 Replies | 1445 Views | Created by DRSCPA - Monday, January 1, 2018 5:45 PM | Last reply by Deepak Saradkumar Panchal - Thursday, January 18, 2018 8:35 AM -
1 Votes
How to record the highest level an item has reached
I mentioned "not complete" only because your solution would overwrite any value selected in the difficulty level.Answered | 7 Replies | 986 Views | Created by kiddn - Tuesday, November 18, 2014 8:28 PM | Last reply by kiddn - Wednesday, November 19, 2014 9:38 PM -
0 Votes
Query Revision Fields collectively
In case I opt to go the conventional way of loading work-items and iterating the first revision of each.Answered | 3 Replies | 697 Views | Created by DesaiJay - Wednesday, December 16, 2015 1:44 PM | Last reply by Starian chen - Thursday, December 17, 2015 8:25 AM -
0 Votes
Get Highest Parent ID
--import data create table [Transactions Table] ([Transaction ID] int, [Parent ID] int) insert into [Transactions Table] ...Answered | 5 Replies | 1652 Views | Created by mjmar27 - Tuesday, December 17, 2019 9:12 PM | Last reply by Natiq Rzazade - Thursday, December 19, 2019 5:30 AM -
0 Votes
problems with sorting by highest value
hi, it is displayed in this way: Supplier ID Supplier Name ...Answered | 5 Replies | 1467 Views | Created by JO_MO - Wednesday, January 23, 2013 8:25 AM | Last reply by Sanjeewan Kumar - Wednesday, January 23, 2013 5:06 PM -
3 Votes
Highest unique entry
[ll_dbuser].KUAF as kuaf1 ON kuaf1.ID = capa.ORIGINATOR INNER JOIN livelinkprod.ll_dbuser.DTree as ...Answered | 5 Replies | 4160 Views | Created by Brokenlynx - Tuesday, November 24, 2009 2:57 PM | Last reply by Brian Tkatch - Tuesday, November 24, 2009 3:41 PM - Items 1 to 20 of 924589 Next ›
No announcements
