Answer Posted / bj
select count(1) from <table_name>;
By this also we can count no of rows in a table.
Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
What is data manipulation language?
Define sql delete statement.
What is sqlite format?
When sql appeared?
What does where 1 1 mean in sql?
What is an ndf file?
Is sql injection illegal?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How to run sql statements with oracle sql developer?
What is sql mysql pl sql oracle?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are the qualities of 2nf?
What is consistency?
what is difference between delete and truncate commands? : Sql dba
what is try_catch block in procedure