Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search Coderanch
Advance search
Google search
Register / Login
sanmahicog sanmahicogg
Greenhorn
+ Follow
2
Posts
2
Threads
0
Cows
since Jul 23, 2012
Merit badge:
grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
Ranch Hand Scavenger Hunt
Number Posts (2/100)
Number Threads Started (2/100)
Number Cows Received (0/5)
Number Likes Received (0/10)
Number Likes Granted (0/20)
Set bumper stickers in profile (0/3)
Report a post to the moderators (0/1)
Edit a wiki page (0/1)
Create a post with an image (0/2)
Greenhorn Scavenger Hunt
First Post
Number Posts (2/10)
Number Threads Started (2/10)
Number Likes Received (0/3)
Number Likes Granted (0/3)
Set bumper stickers in profile (0/1)
Set signature in profile
Search for a post/thread (0/3)
Set a watch on a thread
Save thread as a bookmark
Create a post with an image (0/1)
Recent posts by sanmahicog sanmahicogg
Help to develop the Query.
Hi All,
I want the query for the attached data formate, I have tried by using sub query but not able to get the output.
Table Data in Oracle
Sr No Engine Name Rev no Engine Type Engine Color Engine Norms 1 A 1 Export Red BS3 2 A 2 Export Red BS3 3 A 3 Import Grey BS3 4 A 4 Import Grey BS4 5 A 4 Export Yellow BS4 6 A 4 Import Blue BS3 7 B 5 Export Grey BS3 8 B 1 Export Grey BS4 9 B 2 Import White BS3 10 B 3 Import White BS4 11 C 1 Export White BS3 12 C 2 Import Red BS4 Required Output I want the engine data with the highest rev. no. Sr No Engine Name Rev no Engine Type Engine Color Engine Norms 4 A 4 Import Grey BS4 5 A 4 Export Yellow BS4 6 A 4 Import Blue BS3 7 B 5 Export Grey Bs3 12 C 2 Import Red BS4
show more
11 years ago
JDBC and Relational Databases
Qry for Number Of User Connected to SQL/Oracle Database.
What is the query to find the no of user connected to Oracle database or SQL database ?
show more
11 years ago
JDBC and Relational Databases