Interested to Buy Any Domain ? << Click Here >> for more details...
What does “select count(1) from tab” result?
- 10 Answers
- 20721 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gourvendra singh
select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.
| Is This Answer Correct ? | 61 Yes | 6 No |
Answer / vishnu
SELECT COUNT(1) FROM TAB
ANS:It gives the total number of tables,views,synonyms
present in that schema.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / prerna
If tab is table name then it gives total no of rows present
in that table.
| Is This Answer Correct ? | 9 Yes | 7 No |
Answer / sunil
Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
it results out the count of record in the table result
| Is This Answer Correct ? | 1 Yes | 1 No |
select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / phani
It returns the count of all tables for that user.
| Is This Answer Correct ? | 1 Yes | 6 No |
What is on delete set null?
How do you update f as m and m as f from the below table testtable?
What is primary key secondary key alternate key candidate key?
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
What is scope and visibility in PL/SQL?
What is data modelling in sql?
take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
What is difference between stored function and application function?
What is function and procedure in pl sql?
How many triggers can be applied to a table?
Can we group by two columns in sql?
-
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)
