how to find 5th row ?10 11451
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.16 15794
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?6 7989
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?2 6595
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;10 38701
How can I create a table from another table without copying any values from the old table?8 8547
in table there r so many rows write a query which two rows r updated last two day befor?3 7524
How to remove duplicate rows from a table?.3 5716
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?1 4748
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?4 9424
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
Can a view be mutating? If yes, then how?
how to create a test table in your mysql server? : Sql dba
what is a primary key? : Sql dba
How do we use distinct statement? What is its use?
What is the use of stored procedures?
Can you do multiple joins in sql?
how to run 'mysql' commands from a batch file? : Sql dba
What are pl sql data types?
what is the sql query to display current date? : Sql dba
What is the left table in sql?
Why do we use cursors?
Why do we need cursor in pl sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Why schema is used in sql?
What is the mutating table and constraining table?