What does “select count(*) from tab” result?
Answers were Sorted based on User's Feedback
Answer / shivashanker
it will display the total number of tables in the schema.
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / amit kumar jaswal
display count of all rows from relation
| Is This Answer Correct ? | 3 Yes | 7 No |
Answer / kamal kishore kashyap
display all the table which are currently in the schema.
| Is This Answer Correct ? | 0 Yes | 6 No |
Is it possible to create the following trigger: before or after update trigger for each row?
what is an extent ? : Sql dba
If a View on a single base table is manipulated will the changes be reflected on the base table?
Which is better varchar or nvarchar?
Write a query to find the names of users that begin with "um" in sql?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
Can a foreign key be null?
What is a transaction?
Can we interchange parameters in procedure while calling
Why function is used in sql?
Is sql procedural language?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
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)