Interested to Buy Any Domain ? << Click Here >> for more details...
How to fetch common records from two tables?
- 1 Answers
- 1501 Views
- I also Faced
- E-Mail Answers
Answer / mrityunjay dubey
Select column_name from tableA UNION Select column_name from tableB
| Is This Answer Correct ? | 0 Yes | 0 No |
What are all ddl commands?
How do you retrieve the last N records from a table?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is memory optimized table?
7. Where would you look for errors from the database design?
Can you have more than one key in a database?
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
How do I write a cron which will run a sql query and mail the results to agroup?
How do you identify a primary key?
what is auto increment? : Sql dba
What is denormalization in a database?
What is the difference between anonymous block and named block or stored procedure?
-
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)
