I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
Answers were Sorted based on User's Feedback
Answer / ajit
Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;
| Is This Answer Correct ? | 1 Yes | 6 No |
Answer / nannesaheb chinthalacheruvu
Question is not clear..kindly elaborate the same.
As i understand is "Retrive the single row with out using the where clause"...if so the below query may help you to achive the same.
Select e.*,max(rowid) from emp e;
select e.*,min(rowid) from emp e;
| Is This Answer Correct ? | 2 Yes | 14 No |
How to execute a stored procedure?
Where the Pre_defined_exceptions are stored ?
Is sqlite good enough for production?
what is the use of double ampersand (&&) in sql queries?
What is pls_integer in pl sql?
Can we use the cursor's to create the collection in PL/SQL?
Is inner join faster than left join?
What is trigger types in sql?
In a distributed database system, can we execute two queries simultaneously?
What are dml commands?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)