Retrieve one particular row

Suppose if there are 100 rows and you need to retrieve one particular row without using where clause?
  • Interview Candidate
  • 18
  • 7236

Showing Answers 1 - 18 of 18 Answers

trupti

  • Oct 13th, 2011
 

rownum=1

  Was this answer useful?  Yes

Nakul.V

  • Oct 18th, 2011
 

WHERE Clause main purpose is to filter the records based on certain conditions.

So i don't think it is possible to retrieve 1 particular record from a table without using WHERE Clause.

Regards
Nakul.V

Raja

  • Dec 26th, 2011
 

We can use rownum

  Was this answer useful?  Yes

sss

  • Apr 4th, 2012
 

Using Group BY and Having clause

  Was this answer useful?  Yes

Manivasagam

  • Jul 9th, 2014
 

Code
  1. SELECT * FROM AP_SUPPLIERS START WITH VENDOR_ID =10000 CONNECT BY PRIOR VENDOR_ID =SEGMENT1

    2. 

  2. (OR)

    3. 

  3. SELECT * FROM AP_SUPPLIERS CONNECT BY LEVEL<=1

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions