How to get a specific record without using where clause and cursor in sql using select query.

Question

1.00/5 (1 vote)

See more:

SQL-Server

I have a table like this.

EmpCode

101

102

103

104

Suppose a user want to extract any record like 4th row or 2nd row then how to write a query using select statement which gives the exact result without using Where clause.

Is there any way through which we can find the exact record.lets take an example of array then In array if we want to get 3rd record then we can directly use ECode[3] and we get 103 as result.I want to use the same without using any cursor value value and no where clause also.

Posted 25-Jan-12 1:42am

Dharmenrda Kumar Singh

Add a Solution

Comments

manognya kota 25-Jan-12 7:53am

Why do you want to do it?

Amir Mahfoozi 25-Jan-12 8:55am

No

2 solutions

Solution 2

Today! I found the same issue as mentioned by the OP, and after GOOGLING, I landed on this SOLVED POST at CP, but shocked and terrified to see the answered link not working... :(

anyway a bit later after bit more GOOGLING , found an answer to my query,

and thought of sharing it here, just for the sake of other naive's like me for future.

Well. Let comes to the point. if a user wants to search 2nd row of a table without using WHERE clause.

the following chunk comes into the play. :)

SQL

SELECT TOP 1 T.* FROM
(SELECT TOP 2 * FROM TableName ORDER BY ID ASC) AS T
ORDER BY T.ID DESC;

The logic is pretty simple, Inner Query gets the nth number of rows i.e. 2 top rows in this case, and than outer query descended that result and get the top of that. :)

Hope it will help. :)

Posted 8-Apr-14 2:59am

VICK

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manognya kota · Accepted Answer · 2012-01-25T01:53:00

Solution 1

Hi,

check this out

http://howtoideas.net/how-to-select-nth-row-from-a-table-in-sql-server[^]

Posted 25-Jan-12 1:53am

manognya kota

Comments

fjdiewornncalwe 25-Jan-12 10:01am

Looks like the answer the OP is looking for. +5

manognya kota 26-Jan-12 23:28pm

Thank you Marcus :)