Ques:- What's the difference in HTML AJAX, ASP.Net AJAX?
Asked In :-
CBRE South Asia, Twilio, NAL, Blueshift India, Data Patterns, Avizva Solutions, Tech Tammina, Sterling Software (India), Java R&D, Digital Mesh Softech,
Ques:- Regarding joins what are the differences you observed inoracle 9i and sql server?
Asked In :-
Dhruvsoft Services, Bit Canny Technologies, E2E Research, Shipmnts, Atidan Technologies, AQM Technologies, Fulcrum Logic (I), eGain Communications, Envision Financial Systems India, TekLink International,
Ques:- What are the main differences between ms access and sqlserver
Asked In :-
Cimpress India, CloudMoyo, Inc, Dhyan Infotech, Alcor Solutions, Intune, Ganit Softech, Cosmos Bank, Capline, Volksoft Technologies, Cloud4C,
Ques:- A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?
Asked In :-
MaxVal-IP Services, Attra Infotech, AJIO, Amagi Media, HLS Asia, Galaxy Weblinks, UTS Consultants, Pickrr Technologies, Braves Technologies, Intello Labs,
Ques:- Can we call stored Procedure in Function in Sql Server 2000and vice versa.
Asked In :-
i-exceed technology solutions, GOMO Group AB, RoboSoft, Sarjen Systems, WFP, Payoda, ZF Group, ELDAAS Technologies, DCFM, Finacle Technologies,
Ques:- How do u connect ado.net to sql server
Asked In :-
Razorpay-Startup, scandid, Zyoin Web Pvt., Waffor, Nippon Data Systems, Skill Mine Technologies, FIN Infocom, SSA, ZoomRx, ColorTokens,
Ques:- What is session ?how sessions are handeled in application?write the clauses of sql server in their order.
Asked In :-
Innominds Software (P), Mindgate Solutions, Lorven Technologies, Qualminds Technologies, Maruti Techlabs, CSG Systems, Leo Technologies, SBAR, Thirdware, Testrig Technologies,
Ques:- Difference between Triggers and Stored Procedure
Asked In :-
VAct Technologies, ARMIA SYSTEMS, SimpleMinds Technologies LLP, Magic Software, redBus India, NAV Backoffice, Tech9, Paktolus, Quick Release, Celerix Technologies,
Ques:- Where are connection strings stored?
Asked In :-
Infinity Labs LLP, Hexaview Technologies private, Pennant Technologies, CloudKaptan, Kcloud Technologies, OneOrigin, iauro systems, Rubicon Research, Versant Online Solutions, Kanaka Consulting,
Ques:- What is transaction ? Give me one example.
Asked In :-
Xtreme Softech, Shipmnts, Solugenix India, CodeCraft Technologies, Surya Software, PreludeSys India, ESAF Small Finance Bank, OSI Digital, Ranosys Technologies, Ebaotech,
Ques:- Usage of stored procedure and sql syntax’s.
Asked In :-
AnAr Solutions, Motherson Sumi Infotech Design, C E I India, Surya Software, GrapeCity, SPCL, Signiwis Technologies, 3clogic, Cynet Systems, Princeton Blue,
Ques:- Do you know the query for auto generating the next number in a series ?
Asked In :-
Target Integration, Mind Infotech, Ojas Innovative Technologies, TSS Consultancy, Healthcare Informatics, OneOrigin, Shiash Info Solutions, Softsuave, Kairos Technologies, Imaginea,
Ques:- User management and secirity and package upgrading. kernal upgrading and more ……………………………
Asked In :-
Goldstone Technologies, Samsung R&D Institute India, Proton Expert Systems & Solutions, Infometry, VectoScalar Technologies, AcesoCloud, Nopaperforms Com, De Shaw, Orion Innovation, Cue Health Inc,
Ques:- Difference between self join and inner join ? Indexes where you can use it ? Write a Pivot query in sql ?
Asked In :-
Media Agility, Advanced Business & Healthcare Solutions India, Sequretek IT Solutions, Anlage Infotech (I), Blackbuck Insights, Odessa Technologies, Miracle Software Systems, SpringRole, Ultramain Systems, Polus Software,
Ques:- How to create dynamic sql query in sql server ?
Asked In :-
Itobuz Technologies, C E I India, Aris Global Software, DhruvSoft, Zen Corp Techno Solutions, Dhyan Infotech, Hestabit Technologies, Pennant Technologies, MagicPin, Travelodge Hotels (UK),
Ques:- What are different types of queries and joins in SQL. Explain with the example
Asked In :-
Digital Nirvana Information Systems (I), Codelogicx Technologies, Milliman India, Systematix Infotech, Chella Software, Eternus Solutions, Infiniti Software Solutions, Attra Infotech, MagicPin, Udaan,
Ques:- Sql queries on Join, C, Data Structures (Mostly linked list, stack, queues), Basics of SDLC and Testing.
Asked In :-
Anand Rathi IT, Verticurl Marketing, Network Labs, HARITA TECHSERV, Quantified Commerce, Mobiveil, C-Zentrix, Trak Global, Kira Talent, Key Computer Applications,
Right Answer:
To answer SQL queries on joins, you can use the following examples:
1. **Inner Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
INNER JOIN tableB b ON a.common_column = b.common_column;
```
2. **Left Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
LEFT JOIN tableB b ON a.common_column = b.common_column;
```
3. **Right Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
RIGHT JOIN tableB b ON a.common_column = b.common_column;
```
4. **Full Outer Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
FULL OUTER JOIN tableB b ON a.common_column = b.common_column;
``
To answer SQL queries on joins, you can use the following examples:
1. **Inner Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
INNER JOIN tableB b ON a.common_column = b.common_column;
```
2. **Left Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
LEFT JOIN tableB b ON a.common_column = b.common_column;
```
3. **Right Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
RIGHT JOIN tableB b ON a.common_column = b.common_column;
```
4. **Full Outer Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
FULL OUTER JOIN tableB b ON a.common_column = b.common_column;
``
Ques:- What is derived table?
Asked In :-
Xtreme Softech, Damco Solutions, Smart Cube India, InteQ Software, TFT, Icon Resources, Method CRM, Mantra Technologies, Infovity, Marble Box,
Ques:- How to migrate SSRS reports from one server to another?
Asked In :-
ISG NovaSoft Technologies, Bristlecone India, CodeCraft Technologies, Goldstone Technologies, Spericorn, Signity Solutions, Konnect Insights, Auriga Research, GeoVista Technologies, factset,
Ques:- How to get the last updated identity field value, not necessarily the max value?
Asked In :-
BOM, TFT, Data Patterns, IDP Education, IDeaS - A SAS Company, Tower Research Capital LLC, Java R&D, Rightmove, Key Computer Applications, CETAS Information Technology,
SQL, or Structured Query Language, is the essential tool for anyone working with relational databases. It serves as the universal language for interacting with these databases, allowing users to organize, retrieve, and manage vast amounts of data effectively. Developed in the 1970s, SQL has become the standardized method for database communication across a wide range of applications, from small business systems to enterprise-level data warehouses.
The power of SQL lies in its declarative nature. Instead of telling the computer how to find data, you simply tell it what data you want. This is done through a concise set of commands, such as SELECT to retrieve data, INSERT to add new records, UPDATE to modify existing records, and DELETE to remove them. These commands, often combined with clauses like WHERE to filter data and JOIN to link tables, enable complex data operations with relatively simple statements. For example, a single query can retrieve a list of all customers from a specific city, calculate their total spending, and sort the results by name.
SQL is a foundational technology for data science, business intelligence, and web development. It is used to query databases that power everything from social media platforms to banking systems. Its reliability, efficiency, and widespread adoption make it an indispensable skill for database administrators, developers, and data analysts. Mastering SQL provides the ability to unlock insights from data, maintain data integrity, and build robust, data-driven applications.
