what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
- 0 Answers
- 802 Views
- I also Faced
- E-Mail Answers
what are the demerits of sql?
when normalization is required
What are sql procedures?
What are the two characteristics of a primary key?
What is the difference between an inner join and an outer join?
Is id a reserved word in sql?
how to delete an existing column in a table? : Sql dba
What is the most important ddl statements in sql are?
does sql support programming? : Sql dba
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
What is the difference between microsoft access and sql server?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
